How can you use IF looking at a column, not just a single cell?
 

I am unable to find a way to get the IF function to look for a match in any
of the cells within a column and return yes or no accordingly. I thought it
would be just inserting the column name instead of the single cell name.
i.e.; =IF(B9=C:C, "Yes", "No"). But this does not work.

How can you use IF looking at a column, not just a single cell?
 

One way, in say D9:
=IF(B9="","",IF(ISNUMBER(MATCH(B9,C:C,0)),"Y","N") )
Copy D9 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JHolmes" wrote:
I am unable to find a way to get the IF function to look for a match in any
of the cells within a column and return yes or no accordingly. I thought it
would be just inserting the column name instead of the single cell name.
i.e.; =IF(B9=C:C, "Yes", "No"). But this does not work.

How can you use IF looking at a column, not just a single cell?
 

=IF(COUNTIF(C:C,B9)0,"Yes","No")

"JHolmes" wrote:

I am unable to find a way to get the IF function to look for a match in any
of the cells within a column and return yes or no accordingly. I thought it
would be just inserting the column name instead of the single cell name.
i.e.; =IF(B9=C:C, "Yes", "No"). But this does not work.

How can you use IF looking at a column, not just a single cell
 

I use this method often but sometimes need something like
=if(or(B9=C:C),"yes","No")
entered as array
(control-shift-enter)

"Teethless mama" wrote:

=IF(COUNTIF(C:C,B9)0,"Yes","No")

"JHolmes" wrote:

I am unable to find a way to get the IF function to look for a match in any
of the cells within a column and return yes or no accordingly. I thought it
would be just inserting the column name instead of the single cell name.
i.e.; =IF(B9=C:C, "Yes", "No"). But this does not work.