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
Bookmarks