Adding a new condition

  • Thread starter Thread starter Shhhh
  • Start date Start date
S

Shhhh

Hello all,

The formula below works perfectly...
=IF(B35="","",IF(K34="W","A",LOOKUP(P34,{"A","B","C","D","E","F"},
{"B","C","D","E","F","A"})))

However a new issue has come up that I must try to deal with...
Suppose I'm entering this formula in cell P35. How can I add a line
that says IF H35 = "PPD" then ignore lookup and put the contents of
cell P34 here?

Thank you all for your help!
 
Surely, you can figure it out from the existing formula. You must also
decide precedence of importance because if the 1st condition is met, the
others are ignored, etc.
 
You need to give more info.

Your new variable could go anywhere in 3 different places in your formula,
depending on your preference.
 
Back
Top