|
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, |
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, |
| All times are GMT +1. The time now is 02:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com