More than one iserror in a formula???

[donh]

I am trying to create a vlookup for sequential dates

In the table it is looking up there could be as many as 3 dates not there

Can an iserror statement be built for this to look back to the last valid date?

row dates vlookup from another table
A B C
10 1/10/2000 9.66
11 1/11/2000 9.51
12 1/12/2000 9.76
13 1/13/2000 9.71
14 1/14/2000 10.12
15 1/15/2000 #N/A
16 1/16/2000 #N/A
17 1/17/2000 #N/A

I would like for the value in rows 15, 16, 17 to be 10.12

I can get one iserror to work with date -1 to look above but when a second iserror is working in the formula when I copy it for the entire range the vlookup in row 14 (which is correct) changes to the value that is in row 13.

Currently this is what I have in column C:
=IF(ISERROR((IF(ISERROR(VLOOKUP(A16,table,7,FALSE)),VLOOKUP(A16-1,table,7,FALSE),VLOOKUP(A16,table,7,FALSE)))),VLOOKUP(A16-2,table,7,FALSE),VLOOKUP(A16-1,table,7,FALSE))

Thanks

Don

 

[Domenic]

I'm not sure as to your intent, but assuming that A10:B17 contains the data...

To return the last numerical data...

=LOOKUP(9.99999999999999E+307,B10:B17)

To return the corresponding date...

=LOOKUP(9.99999999999999E+307,B10:B17,A10:A17)

Hope this helps!