Adding a new condition

[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!

 

[Don Guillett]

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.

 

[Ragdyer]

You need to give more info.

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