ExcelBanter - nested if doesn't work

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - nested if doesn't work (https://www.excelbanter.com/excel-discussion-misc-queries/152391-nested-if-doesnt-work.html)

Janis

nested if doesn't work

This formula doesn't work, it looks like it should work:

=IF(ISNA(VLOOKUP(B4,'07-17-07'!B5:I70,8,FALSE)),
IF(ISNA(VLOOKUP(B4,'07-10-07'!B5:I66,8,FALSE)),
VLOOKUP(B4,'07-03-07'!B5:I66,8, FALSE), VLOOKUP(B4,'07-10-07'!B5:I66, 8,
FALSE)), VLOOKUP(B4,'07-17-07'!B5:I70,8,FALSE))

If I do the lookups separately they work.

Janis

nested if doesn't work

Sorry my fault,The nested if does work, it was a lot of typos.

"Janis" wrote:

This formula doesn't work, it looks like it should work:

=IF(ISNA(VLOOKUP(B4,'07-17-07'!B5:I70,8,FALSE)),
IF(ISNA(VLOOKUP(B4,'07-10-07'!B5:I66,8,FALSE)),
VLOOKUP(B4,'07-03-07'!B5:I66,8, FALSE), VLOOKUP(B4,'07-10-07'!B5:I66, 8,
FALSE)), VLOOKUP(B4,'07-17-07'!B5:I70,8,FALSE))

If I do the lookups separately they work.

All times are GMT +1. The time now is 02:27 AM.