Lookup Question

[kaobeikaobei]

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!

[scottylad2]

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.

ok, what determines what is prefilled with Yes or Blank

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!

Most likely you will have an If formula that will start say in B1 along the lines of, IF(or(A1=2,A1=4),"","yes") which will leave B1 blank there's a 2 or 4 in A1, otherwise a Yes will show. You then drag that Formula down the whole column where there's applicable data.

The key to making it work is what are the values that will return a blank and work into the formula provided

[kaobeikaobei]

Hi, thanks for the quick response!

What determines whether or not a yes is input is independent of the excel spreadsheet and determined by an external source.

I was wondering if it was possible to have a formula that would not have to go into column B and instead reference column A and then change column B accordingly. This is because I do not want the prefilled data in column B to be corrupted, I merely want to eliminate the "yes"s from column B that have a connected value in column A that do not warrant a "yes". I know that values 2 and 4 should not have a yes, so I just want to remove these "yes"s from the spreadsheet, without affecting the existing data. This is the only reason that blanks are to be implemented, I do not wish to add anymore "yes" inside column B.

Sorry if my wording is unclear, thank you for your time.