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

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

Guest

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.
 
One way, in say D9:
=IF(B9="","",IF(ISNUMBER(MATCH(B9,C:C,0)),"Y","N"))
Copy D9 down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting Text from single cell in column across multiple Columns 3
With F1 value, look at A, if match or partial match return B 5
Help formula that returns a text string from another sheet 1
Function that will look at letter in a column and return a number 3
Lookup multiple cell values and place contents in a single cell 3
How to SUM entire column, but only when adjacent cell is not empty 3
count nonblank cells 3
A find formul looking at two named ranges for two strings 6

Back
Top