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