Vlookup mixed with IF, looking at a date.

Good evening happy campers.

Please see attached.

Sheet1 Cell A1 - todays date (=today() )
C3 - (formula here)
Sheet2 Range A:B - 'DATA'

I would like C3 (sheet1) to show me the name from sheet 2 that is closest to the next date on sheet2 (closest to A1 Sheet1)

Initially i thought a nested IF within Vlookup would do it but i cant get my head round it, could someone kindly turn the light on for me?

kind regards, galvinpaddy