I have a column (column A) with values such as 1,2,3,4. The column (column B) next to this is prefilled with a response, "yes" or a blank.
I need a formula that will reference column A and eliminate the "yes" from column B depending on the number displayed in column A.
For example, I know that values of 2 and 4 do not have a "yes" and so I need a formula to take these yes out, be using "lookup"? Or by using some other "if" function combined with a lookup statement to take out the "yes" values without overwriting them (ie one formula for the entire columns)
Thanks in advance!
Bookmarks