nested if doesn't work

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3 deep nested if gets the same value on every cell. 1
nested if 3
and and if functions 1
Vlookup - ISNA function 4
Counting if Date1 is after and Date2 is before another date 5
Multiple if statements with multiple conditions 4
Summing related cell values and returning total to summary 2
Can SUMPRODUCT work on changing arrays? 5

Top