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
Hello,

I have list of 1000 company names in col A and in col B 20,000 company names. I would like to know if the company in A appears anywhere in B and show result in C. ? eg

CNA Group Pte Ltd CNA Group Pte. Ltd. CNA Group Pte. Ltd.


Many thanks for your help.

David




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
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.
I think its too exact. Although the companys name is the same the addition of full-stops in col b has to be taken into account ?

A B C
CNA Group Pte Ltd CNA Group Pte. Ltd. CNA Group Pte. Ltd.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 20, 2012 at 06:53 AM
sounds like you need fuzzy lookup
see if this helps
http://www.ncorpus.com/aydingurel/codes_vba/vba_fuzzyvlookup.html