Hi
I`d be happy if someone helped me with this .. i`m trying to compare data between two columns or tables, and if they match I`d like to get the result of column G.


For example if there is a match between B2 - F2 then i`l get the result of column G2 and so on throughout the table..
file is attached..

Thanks

Attached Files

FULL2.xlsx (97.4 KB, 15 views)

Is it like the attached?

Attached Files

FULL_3.xlsx (113.6 KB, 12 views)

Many thanks ... I just forgot to explain that the comparison should actually be on the entire F column not just F2 ..how do I change it ?

F2 is checked against B2:B1002. Similarly for F3, F4, ..... , F1869

What exactly is wrong in column H? Plese show excamples.

Sorry for the late response .. my goal is to check each cell in the B column against entire F column . and to obtain the result of the symbol listed next to it (cell G).

Next issue is, that the names in Column B and Column F do not match 100 percent, but the first word usually does .
Is there a way to overcome this as well ?

OKay
and what's to be done with that?

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..

Apart from the not exact match is this what you want

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

Attached Files

FULL_4.xlsx (112.5 KB, 9 views)

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

Attached Images

	1.JPG (43.0 KB, 17 views)
	2.JPG (28.2 KB, 16 views)

You didn't answer my question in the first line of #8

As to the not exact match problem you might want to take a look at:

https://www.microsoft.com/en-us/down....aspx?id=15011

Thank you sir ... i found a solution for my problem.. i`m ttaching the file .

Attached Files

FULL5.xlsx (156.2 KB, 9 views)