3 deep nested if gets the same value on every cell.

[Guest]

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,

 

[Guest]

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))