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.