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.

=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.

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

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

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


On Jan 11, 4:11*pm, TrevorC wrote:
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- Hide quoted text -

- Show quoted text -