Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
This vlookup works for the sheet its on, but if it doesn't find it I want it
to check the weekending for the 2 previous sheets respectively. =VLOOKUP(B46,'07-17-07'!B45:I112,8,FALSE) What I want to know is will this work to nest the if's. if(=VLOOKUP(B46,'07-17-07'!B45:I112,8,FALSE),=VLOOKUP(B46,'07-10-07'!B45:I112,8,FALSE),=VLOOKUP(B46,'07-3-07'!B45:I112,8,FALSE)) tia, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
You really need a construct like this:
=IF(ISNA(vlookup_1),IF(ISNA(vlookup_2),IF(ISNA(vlo okup_3),"not present",vlookup_3),vlookup_2),vlookup_1) So, your formula would be: =IF(ISNA(VLOOKUP(B46,'07-17-07'! B45:I112,8,0)),IF(ISNA(VLOOKUP(B46,'07-10-07'!B45:I1* 12,8,0)),IF(ISNA(VLOOKUP(B46,'07-3-07'!B45:I112,8,0)),"not present",VLOOKUP(B46,'07-3-07'!B45:I112,8,0)),VLOOKUP(B46,'07-10-07'! B45:I1*12,8,0)),VLOOKUP(B46,'07-17-07'!B45:I112,8,0)) I've replaced FALSE with 0 to make it a bit shorter, but this is all one formula so be wary of spurious linebreaks if copy/pasting from the newsgroups. Hope this helps. Pete On Jul 27, 11:26 pm, Janis wrote: This vlookup works for the sheet its on, but if it doesn't find it I want it to check the weekending for the 2 previous sheets respectively. =VLOOKUP(B46,'07-17-07'!B45:I112,8,FALSE) What I want to know is will this work to nest the if's. if(=VLOOKUP(B46,'07-17-07'!B45:I112,8,FALSE),=VLOOKUP(B46,'07-10-07'!B45:I1*12,8,FALSE),=VLOOKUP(B46,'07-3-07'!B45:I112,8,FALSE)) tia, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
Janis wrote...
This vlookup works for the sheet its on, but if it doesn't find it I want it to check the weekending for the 2 previous sheets respectively. .... What I want to know is will this work to nest the if's. if(=VLOOKUP(B46,'07-17-07'!B45:I112,8,FALSE), =VLOOKUP(B46,'07-10-07'!B45:I112,8,FALSE), =VLOOKUP(B46,'07-3-07'!B45:I112,8,FALSE)) You'd need something like =IF(1-ISNA(VLOOKUP(B46,'07-17-07'!B45:I112,8,0)), VLOOKUP(B46,'07-17-07'!B45:I112,8,0), IF(1-ISNA(VLOOKUP(B46,'07-10-07'!B45:I112,8,0)), VLOOKUP(B46,'07-10-07'!B45:I112,8,0), IF(1-ISNA(VLOOKUP(B46,'07-3-07'!B45:I112,8,0)), VLOOKUP(B46,'07-3-07'!B45:I112,8,0),""))) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
One way:
=IF(ISNA(MATCH(B46,'07-17-07'!B45:B112, FALSE)), IF(ISNA(MATCH(B46,'07-10-07'!B45:B112, FALSE)), VLOOKUP(B46,'07-03-07'!B45:I112, 8, FALSE), VLOOKUP(B46,'07-10-07'!B45:I112, 8, FALSE)), VLOOKUP(B46,'07-17-07'!B45:I112,8,FALSE)) In article , Janis wrote: This vlookup works for the sheet its on, but if it doesn't find it I want it to check the weekending for the 2 previous sheets respectively. =VLOOKUP(B46,'07-17-07'!B45:I112,8,FALSE) What I want to know is will this work to nest the if's. if(=VLOOKUP(B46,'07-17-07'!B45:I112,8,FALSE),=VLOOKUP(B46,'07-10-07'!B45:I112, 8,FALSE),=VLOOKUP(B46,'07-3-07'!B45:I112,8,FALSE)) tia, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested IF | Excel Discussion (Misc queries) | |||
Nested IF | Excel Discussion (Misc queries) | |||
Nested if | Excel Worksheet Functions | |||
Need HELP with NESTED IF | Excel Discussion (Misc queries) |