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