Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If within an If...
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 *** |