Match text values between two tables

Hello all!

I would appreciate your help in the following:

- I have 2 sheets, each sheet has a number of cells with destination names (cities).
- 1 sheet has more/other destinations than the second one
- I want to make a third sheet which compares the 2 sheets, and checks which destinations are the same, and which differ. So basically if I know for example which destinations are not matching in the two sheets. Is this possible?

Thank you for all your ideas and contributions. Have a great day!

- Hans

Hi awsz,

You can use vlookup function to know what are the cities that do not show up in the list with lesser city names from the other sheet.
If you need help with creating the formula maybe u can attach an workbook with before and the outcome sheet that u want so it will be easier for people to help you.

Jul

Attached, thank you guys.

As Jul Stev said, vlookup should work.

type this formula in b2 and drag or just double click the small square in the down right of cell highlight black box

=IFERROR(IF(VLOOKUP(A2,$C$2:$C$1178,1,FALSE)>0,"YES","NO"),"NO")

You can definitely simplify this.. But need to know whether this works for you.

Originally Posted by elayaz

As Jul Stev said, vlookup should work.

type this formula in b2 and drag or just double click the small square in the down right of cell highlight black box

=IFERROR(IF(VLOOKUP(A2,$C$2:$C$1178,1,FALSE)>0,"YES","NO"),"NO")

You can definitely simplify this.. But need to know whether this works for you.

Thanks. I tried it (with ; instead of ,) but I'm getting an #NAME? error

Originally Posted by Fotis1991

=countif($c$2:$c$1178,a2)>0 ????

What do you mean with the question marks?

Originally Posted by Fotis1991

i just ask if my formula works for you!

Oeps, haha, I copied it along the formula earlier. Looks like you solved both of my questions today, repped for sure. Thanks again Fotis!

Are you using a non-English excel version?. It works perfect in the attached file.

See if this helps..