I have a table of data such as below in Excel. I would love to know how to find the nearest value to the correct data. So a worked example I can do a VLOOKUP or INDEX MATCH for 6th Jan. However if I lookup for 8th Jan I will get 0, but I want to get the nearest value, or if easier I would like to get the last known previous value from the next column which is 103. For the 19th Jan I would like 92 etc. I can code this up in VBA but I would really like an Excel formula to do this and I can't think how to do it!
╔═══════════╦═══════╗
║ Date ║ Value ║
╠═══════════╬═══════╣
║ 05-Jan-14 ║ 102 ║
║ 06-Jan-14 ║ 103 ║
║ 07-Jan-14 ║ ║
║ 08-Jan-14 ║ ║
║ 09-Jan-14 ║ ║
║ 10-Jan-14 ║ ║
║ 11-Jan-14 ║ ║
║ 12-Jan-14 ║ 99.9 ║
║ 13-Jan-14 ║ ║
║ 14-Jan-14 ║ ║
║ 15-Jan-14 ║ ║
║ 16-Jan-14 ║ ║
║ 17-Jan-14 ║ ║
║ 18-Jan-14 ║ 92 ║
║ 19-Jan-14 ║ ║
║ 20-Jan-14 ║ ║
║ 21-Jan-14 ║ 94 ║
╚═══════════╩═══════╝
