Hi Darin,

Try this :-

=IF(F56="","",IF(P56=10.1,VLOOKUP(P56,$A$56:$E$200 ,5,0),VLOOKUP(N56,$A$5
6:$E$200,5,0)))

All the Best.
Paul



From: Darin Kramer

Howdie,

My current if states

IF(F56="","",(VLOOKUP(N56,$A$56:$E$200,5,0)))

I now want to add the condition that if cell p56=10.1 then instead of
doing the vlookup on N56, do it on P56.

So Basically three condions
1)if F56 is blank, put blank
2)If F56 is not blank, then is P56 = "10.1"? If P56 is equal to 10.1, do
do the Vlookup on P56, and if its not equal to 10.1 do the Vlookup on
N56
Note Both conditions can not be true, ie P56 can not be 10.1 and f56 be
blank at the same time. Range is always the same.

Whats the new all encompassing IF ? :)

Confusing..? hope not!




*** Sent via Developersdex http://www.developersdex.com ***