LOOKUP/IF formula

  • Thread starter Thread starter KLR
  • Start date Start date
K

KLR

I am trying to create a formula in Column C that looks
down column A and if the text in the cell says YES then
the cell displays the value from column B (cell next
door). However if the text says NO, then the cell is to
contain either nothing, or display zero. HELP!
 
You wouldn't use a vlookup formula for this, unless only one cell could say
YES and you wanted only one value from the same row and were going to put
this formula in only one cell.

You can use an IF statement in column C, for example
=IF(A1="Yes",B1,"")
and copy it down.

however, this will not "look down column A". It doesn't seem to make any
sense to do so, unless I'm misunderstading your need.
 
Back
Top