Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AND
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AND
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. -- Rick (MVP - Excel) "geebee" (noSPAMs) wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AND
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,F ALSE)),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,F ALSE)),"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" (noSPAMs) wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|