Vlookup ?

[Closed]
Report
Posts
1
Registration date
Thursday December 20, 2012
Status
Member
Last seen
December 20, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
119
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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
sounds like you need fuzzy lookup
see if this helps
http://www.ncorpus.com/aydingurel/codes_vba/vba_fuzzyvlookup.html