Vlookup ?
Closed
David-59
Posts
1
Registration date
Thursday December 20, 2012
Status
Member
Last seen
December 20, 2012
-
Dec 20, 2012 at 04:32 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 20, 2012 at 06:53 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 20, 2012 at 06:53 AM
Related:
- Vlookup ?
- If iserror vlookup - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Excel 2007 Using vlookup function in VBA ✓ - Excel Forum
- Using Vlookup to return insted of 00/01/1900 ✓ - Excel Forum
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Dec 20, 2012 at 06:06 AM
Dec 20, 2012 at 06:06 AM
Use This Formula in column C
=Vlookup(A:A,B:B,1,False).
If company Name Appears in Column C Means the company Exist in column B and if #N/A Appears that mean this company name is not in Column B.
=Vlookup(A:A,B:B,1,False).
If company Name Appears in Column C Means the company Exist in column B and if #N/A Appears that mean this company name is not in Column B.
Dec 20, 2012 at 06:30 AM
A B C
CNA Group Pte Ltd CNA Group Pte. Ltd. CNA Group Pte. Ltd.
Dec 20, 2012 at 06:53 AM
see if this helps
http://www.ncorpus.com/aydingurel/codes_vba/vba_fuzzyvlookup.html