IF statement between two worksheets

[TrevorC]

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.

 

[JP]

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


HTH,
JP

 

[JP]

Also

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


HTH,
JP

 

[TrevorC]

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

Any other ideas?

 

[JP]

Do you mean there are values in column E that exactly match A1 but the
formula still comes up blank? Can you provide more information?

Keep in mind, both formulas are checking on an exact match of A1, if
there are spaces in the cell, it might be missed. You could use the
LEN() function on A1 and the cell you suspect is being missed, if they
are equal to each other then we can go from there.


HTH,
JP