AND

[geebee]

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

 

[Rick Rothstein]

Use the AND() function. Change the first part (of your first line) to
this...

=IF(And(Condition1,Condition2,ISERROR(VLOOKUP($B1,'DATA'!$B$1:$J$200,5,FALSE))),

where Condition1 and Condition2 are expressions that result in TRUE or FALSE
results.

 

[Ronald R. Dodge, Jr.]

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