Comparing two columns

NoSparks · #1 05-20-2018, 01:37 PM

Quote:

my goal is to check each cell in the B column against entire F column

OKay

Quote:

and to obtain the result of the symbol listed next to it (cell G)

and what's to be done with that?

rooly · #2 05-20-2018, 02:43 PM

as yuo`v seen...i have two tables side by side ,company name and its symbol. I need a formula that will lookup for columns A or B in the list of column F or G. And getting the result in column H ...

The problem is that there is not always accurate match between columns, for example in column A symbol might be described AABA. and in column G registered AABA.O ..

Also the company's full name is sometimes registered differently, for example column A the company's full name described -Agilent Technologies, but in column G - AGILENT TECH.
If you have a solution for that i would be very happy..

xor · #3 05-20-2018, 11:02 PM

Apart from the not exact match is this what you want

If it is please describe exactly how the names can differ.

rooly · #4 05-20-2018, 11:48 PM

Thanks again for your help. I'll attach screen shots...
i would be very happy if you can solve this problem...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing two sentences in two different columns	JoAndRoPo	Excel	5	08-07-2014 07:44 AM
Error comparing and getting result of between Two columns	shilabrow	Excel	4	06-19-2014 03:36 AM
Comparing 2 columns of Text	Berk21	Excel	9	02-03-2012 12:19 PM
Advanced Filter - Comparing Two Columns	apolloman	Excel	5	07-27-2011 04:54 AM
macro for comparing data from 3 columns and pasting into another worksheet	ashukla	Excel	1	06-24-2009 05:01 PM