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

Vlookup ?
Using Vlookup to return insted of 00/01/1900 ✓ - Excel Forum
Transfer data from one excel worksheet to another automatically vlookup - Guide
Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum

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.

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.

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

Similar discussions

Concanating text using vlookup forumula

Compare values in two columns and return the value from third

Conditional Formatting in a vlookup

Find missing data in 2 columns (Excel)

Automatically transfer data from one sheet to another

Similar discussions

Subscribe To Our Newsletter!