Previous Topic Next Topic

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

Answer 1 / 1
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.
0
David-59
Dec 20, 2012 at 06:30 AM
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.
0
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
0

Similar discussions

Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Concanating text using vlookup forumula
gannesh0604 -
gannesh0604 -

0 responses
Conditional Formatting in a vlookup
attycuz -
TrowaD -

1 response
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses