=IF(A1=B1,"match","no match")

and then copy down column C
--
Gary's Student


"Adam" wrote:

Hi,

I have two columns of text that I want to compare.

I need to see whether any of the values in column A are missing from column B.

EG:

A B C

ab4 ah6 no match
ab5 zqv no match
abs abs match
abv abv match

Hopefully it can give something like Column C as the result.

I have tried IF statements & functions such as Exact but cant get it to work.

Any help will be very much appreciated.

Many Thanks.