| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nested vlookup does not work | Excel Worksheet Functions | |||
| I am having difficulty getting nested subtotals to work anymore?! | Excel Worksheet Functions | |||
| Why doesn't the INDIRECT function work when nested in FREQUENCY? | Excel Worksheet Functions | |||
| Why doesn't this nested IF statement work? | Excel Worksheet Functions | |||
| Nested IF - Work Around for 7 nest Max | Excel Worksheet Functions | |||
Linear Mode
