Thanks. This is kind of working but I know there are matching values that
are not being detected.

Any other ideas?

"JP" wrote:

Also

=IF(COUNTIF(Sheet2!E:E,A1),"match","false")


HTH,
JP

On Jan 11, 3:21 pm, JP wrote:
=IF(ISNA(VLOOKUP(A1,Sheet2!E:E,1,FALSE)),"false"," match")

HTH,
JP