IF & Vlookup Formula

[mwhit]

Hello- Need help to determine what formula(s) i should use:

Current formula: =if F22=1,F11,(vlookup) This formula works just fine!

My issue is that I need to add another criteria: F23="a"

Basically, I will like to keep the current formula BUT add another if statement for F23="a" and if F23 is true I will like to pull another cell (D12) and if its not true I would just use my current vlookup formula.

need help on writing the correct formula in one cell. Any thoughts??

 

[Peter_SSs]

Not all that clear but maybe this?

=IF(F23="a",D12,IF(F22=1,F11,VLOOKUP(...)))

 

[CharlesChuckieCharles]

Try using the AND function


=IF(AND(F22=1,F23="a")F11,VLOOKUP(.....

AND is if EVERY condition is true

also OR

OR is if ONE condition is true

=IF(OR(F22=1,F23="a")F11,VLOOKUP(.....
would be IF F22-1 or F23 -"a"

You can nest them

This should be enough to work out what you need

 

[mwhit]

Not all that clear but maybe this?

=IF(F23="a",D12,IF(F22=1,F11,VLOOKUP(...)))

Excellent. I knew it had to be a simple way. Thanks Peter.