Hi all,

apologies upfront for not beeing nowhere near the solution with reading older posts....

I have a rather boring jjob :-) and I part of it is to compare my companies capabilities in countries with the countries of our clients.....

To explain I have a table in excel stating following (thats where we are)

A1
country1
country 2
country 3
country 4
.
.
.


country 156

and I get a another column where they tell me in the same way where they are.

country 1
country 2

while it is easy for lets say 5 countries mostly I have to check if 120 of there countries are matching with our 156 and I do that one by one. Is there a formula that can do that and if yes could that formula if it find a match in the two colums "print" in a third coplumn the name of our copany there which I have in column 3,4 and 5 (Name, Contact, Emailadress)

I have attached an example how it should look like by filling it out manually as I always do.....

Thanks much and have a great day!.

Attached Files

Book1.xls (15.0 KB, 29 views)