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

J

JHolmes

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

Max

One way, in say D9:
=IF(B9="","",IF(ISNUMBER(MATCH(B9,C:C,0)),"Y","N"))
Copy D9 down
 
Top