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.