Return value of "YES" when range contains one cell that has data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 5 columns, the first 4 containing lookup functions that return either #N/A or a value of N44255 XX X XXXX where X can be any combination of digits
In the 5th column, I want it to look at the first 4 columns. If ANY ONE of them contain "N" in the first place, I want it to return a YES in the 5th column, otherwise a NO. And truthfully, I just want the YES's to show. I don't care if it returns another #N/A

I have tried so many formulas and can get them to work for a single cell..and as soon as I try to look at the range, it fails

A1 A2 A3 A4 A
#N/A N44255 02 C 0001 #N/A #N/A RETURN A "YES
N44255 03 P 2156 #N/A #N/A #N/A RETURN A "YES
#N/A #N/A #N/A #N/A Return a NO
 
One way

=IF(COUNTIF(A2:D2,"N*"),"Yes","No")

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Beth Dye said:
I have 5 columns, the first 4 containing lookup functions that return
Click to expand...
either #N/A or a value of N44255 XX X XXXX where X can be any combination of
digits.
In the 5th column, I want it to look at the first 4 columns. If ANY ONE
Click to expand...
of them contain "N" in the first place, I want it to return a YES in the 5th
column, otherwise a NO. And truthfully, I just want the YES's to show. I
don't care if it returns another #N/A.
I have tried so many formulas and can get them to work for a single
Click to expand...
cell..and as soon as I try to look at the range, it fails.
A1 A2 A3 A4 A5
#N/A N44255 02 C 0001 #N/A #N/A RETURN A "YES"
N44255 03 P 2156 #N/A #N/A #N/A RETURN A "YES"
#N/A #N/A #N/A
Click to expand...
#N/A Return a NO
 
That worked perfectly. Thank you.

Peo Sjoblom said:
One way

=IF(COUNTIF(A2:D2,"N*"),"Yes","No")

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


either #N/A or a value of N44255 XX X XXXX where X can be any combination of
digits.
of them contain "N" in the first place, I want it to return a YES in the 5th
column, otherwise a NO. And truthfully, I just want the YES's to show. I
don't care if it returns another #N/A.
cell..and as soon as I try to look at the range, it fails.
#N/A Return a NO
Click to expand...
 
Thanks for the feedback..

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
Back
Top