IF Statement

[DarrenF]

I'm trying to search a column for a specific number in a different sheet and its returning all "false" (NO) information every time.

Here's what I'm using, =IF(Sheet8!A:A=BE2,"YES","NO") Both Sheet8 Column A and BE have a 10 digit phone number in the following format 4704540778

 

[jtakw]

Hi,

Unless the Entire Sheet8! Column A = BE2, you'll always get "NO", try this:

=IF(COUNTIF(Sheet8!A:A,BE2),"YES","NO")

 

[DarrenF]

Hi,

Unless the Entire Sheet8! Column A = BE2, you'll always get "NO", try this:

=IF(COUNTIF(Sheet8!A:A,BE2),"YES","NO")

 

[DarrenF]

Thank you jtakw! I was not aware of that. Appreciate the quick response, that worked.

 

[jtakw]

You're welcome, thanks for the feedback.