Vlookup mixed with IF, looking at a date.

Ho Fotis,

Yes, your formula works fine if the date matches one from Sheet2.
But - the date in Sheet1 A1, is set as =TODAY() so this will change according to the date it is opened, so i would then need to see the next name on the list.
Kind regards, galvinpaddy.