IF statement between two worksheets
 

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 statement between two worksheets
 

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

IF statement between two worksheets
 

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

IF statement between two worksheets
 

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

IF statement between two worksheets
 

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 -