Expert Required: How to display the values of a date or the next earliest date

[newtotheblock]

excel help.xlsxHi All,

Im trying to find a way so that if a date isnt available in a table that it would then show the next earliest date.

I have attached a spreadsheet to better display what I am trying to achieve

When the date I am trying to Vlookup doesnt exist in the raw data I want it to display the next earliest date (I.e Vlookup Value: Dec 10. If December 10th doesnt exist in the raw data I want it to display Dec 8th which does)

You will notice that under two of the dates it displays an error this is because those dates dont exist on the raw data

Thank you

[newtotheblock]

Here is a picture of how the spreadsheets looks for those who dont want to download the workbook

Capture1.PNG

Capture.PNG

[samba_ravi]

Try =VLOOKUP(D3,Sheet2!$A$2:$B$83,2,1) instead of =VLOOKUP(D3,Sheet2!$A$2:$B$83,2,0)

[Sean Thomas]

you need to change the date Dec-13 to text then use =VLOOKUP(DATEVALUE(D3),Sheet2!$A$2:$B$83,2,1)