Help Needed in Text match

[Sampat]

Hello!

First of all, I want to Thank All the lovely people in the forum. They helped me a lot in all my previous problems and making my life lot easier!

This time, I'm facing a little difficulty in matching some data.

I have two colum A & B, both contains some place name. In few row the names are equal, in few rows, they are not. e.g. A2=Paris, B2=Spain; A3=London, B3=India; A4=Delhi, B4=Delhi and so on.

Now I need to identify where there are same, where different.

I have tried with the following formula- =IF(B2=A2, Match, Mismatch), But it returns "#NAME?" error.

Please do advice me how could I resolve the same. Thanks in advance!

 

[GTO]

If I am understanding, you just need to add quotes to the string values you are looking to return:

=IF(B2=A2, "Match", "Mismatch")

 

[Yahya]

you forget to add Double qutation
=IF(B2=A2, "Match", "Mismatch")

 

[Sampat]

Awesome!

Thank you Both!

Keep up the good work