URGENT - I need help with INDEX / VLOOKUP and looking up a value

[jim.thornton]

Table:

1/12/17, value1
1/13/17, value2
1/16/17, value3
1/17/17, value4


I have an appointment at 9am tomorrow morning and I need to get this fixed by then. I would really appreciate some help!

I need to create a formula which will retrieve a spreadsheet date from say column N1. Then, the formulate needs to search the date in the list and find the value next to it. HOWEVER, if the date is not in the list then it needs to return the previously listed date.

FOR EXAMPLE:

N1 = 1/12/17 --> The value returned would be value1
N1 = 1/14/17 --> The value returned would be value2
N1 = 1/15/17 --> The value returned would be value2
N1 = 1/16/17 --> The value returned would be value3

Can somone please help me? My formula is returning #N/A for a date that is not listed and I can't figure out how to return the previous date in the list.

=VLOOKUP(N1,'Sheet1'!A:B,2,FALSE)

 

[ExcelElliott]

Try using TRUE as the 4th argument, assuming the list you're looking up from is sorted oldest to newest.