Vlookup mixed with IF, looking at a date.

Hi Glavinpaddy,


For nearest match, you can use Vlookup with True :-
Use below in cell C3:-

=VLOOKUP(A1,Sheet2!A:B,2,TRUE)

regards,
DILIPandey

<click on below 'star' if this helps>