If you talking about the AND() function, it's pretty simple, which the OR()
function also works essentially the same except for the fact it's an OR
between each expression as opposed to it being an AND between each
expression within the AND() function like the following:
=IF(AND(ISERROR(VLOOKUP($B1,'DATA'!$B$1:$J$200,5,FALSE)),ISERROR(VLOOKUP("OTH",'DATA'!$B$1:$J$200,5,FALSE))),"NO
LOOKUP",VLOOKUP("OTH",'DATA'!$B$1:$J$200,5,FALSE))
However, you might be better with the following as long as you don't exceed
a nesting of 7 function levels.
=IF(ISERROR(VLOOKUP($B1,'DATA'!$B$1:$J$200,5,FALSE)),IF(ISERROR(VLOOKUP("OTH",'DATA'!$B$1:$J$200,5,FALSE)),"NO
LOOKUP",VLOOKUP("OTH",'DATA'!$B$1:$J$200,5,FALSE)),VLOOKUP($B1,'DATA'!$B$1:$J$200,5,FALSE))
--
Thanks,
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"geebee" <(E-Mail Removed)(noSPAMs)> wrote in message
news:962AA30E-C21A-452A-B801-(E-Mail Removed)...
> hi,
>
> i have the following:
>
> =IF(ISERROR(VLOOKUP($B1,'DATA'!$B$1:$J$200,5,FALSE)),
> VLOOKUP("OTH",'DATA'!$B$1:$J$200,5,FALSE),
> VLOOKUP($B1,'DATA'!$B$1:$J$200,5,FALSE))
>
> i would like to know how i could add and AND, or actially 2 AND conditions
> to the first part (the first line of this formula).
>
> thanks in advance,
> geebee
>
