Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 deep nested if gets the same value on every cell.
Hi thanks to you I have a formula to find nested ifs. I am currently on the
last sheet 7-24-2007. If there is a #na in the last column then I want it to look for the value on sheet 7/17/2007. If not there I want it to look on the sheet 7/03 in the I column. It would actually be nice if it could just check the last 3 sheets relatively since they add a new one each week? There are different numbers of rows but the same column. In any case I cannot get this nested if 3 deep to work. I get the same value for each cell instead of it matching on a few of them?? =IF(ISNA(VLOOKUP(B4,'07-17-07'!B4:I70,FALSE)), IF(ISNA(VLOOKUP(B4,'07-10-07'!B4:I66,FALSE)), VLOOKUP(B4,'07-03-07'!B4:I66, 8, FALSE), VLOOKUP(B4,'07-10-07'!B4:I66, 8, FALSE)), VLOOKUP(B4,'07-17-07'!B4:I70,8,FALSE)) tia, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 deep nested if gets the same value on every cell.
Couple of "typos" in the first two lookups but it worked fine for me.
Not sure what you mean when you say .... I get the same value for each cell instead of it matching on a few of them?? =IF(ISNA(VLOOKUP(B4,'07-17-07'!B4:I70,8,FALSE)), IF(ISNA(VLOOKUP(B4,'07-10-07'!B4:I66,8,FALSE)), VLOOKUP(B4,'07-03-07'!B4:I66, 8, FALSE), VLOOKUP(B4,'07-10-07'!B4:I66, 8, FALSE)), VLOOKUP(B4,'07-17-07'!B4:I70,8,FALSE)) "Janis" wrote: Hi thanks to you I have a formula to find nested ifs. I am currently on the last sheet 7-24-2007. If there is a #na in the last column then I want it to look for the value on sheet 7/17/2007. If not there I want it to look on the sheet 7/03 in the I column. It would actually be nice if it could just check the last 3 sheets relatively since they add a new one each week? There are different numbers of rows but the same column. In any case I cannot get this nested if 3 deep to work. I get the same value for each cell instead of it matching on a few of them?? =IF(ISNA(VLOOKUP(B4,'07-17-07'!B4:I70,FALSE)), IF(ISNA(VLOOKUP(B4,'07-10-07'!B4:I66,FALSE)), VLOOKUP(B4,'07-03-07'!B4:I66, 8, FALSE), VLOOKUP(B4,'07-10-07'!B4:I66, 8, FALSE)), VLOOKUP(B4,'07-17-07'!B4:I70,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 | |||
IF statement (non nested) that compares cell value against range | Excel Worksheet Functions | |||
too deep formula line | Excel Discussion (Misc queries) | |||
Nested IF statement with cell range reference | Excel Worksheet Functions | |||
color of a cell within a nested if function | Excel Discussion (Misc queries) |