=IF(ISNA(VLOOKUP(A1,Sheet2!E:E,1,FALSE)),"false"," match")


HTH,
JP

On Jan 11, 3:14*pm, TrevorC wrote:
I need to see if a value in column A matches a value in column E of Sheet2.. I
have tried the following:

=IF($A1='Sheet2'!$E$1:$E$100,"match","false")

Any help is appreciated.