Hi Both, thanks for your input
DILIPandey - Thanks, but i would need the next name in the list, the true part of vlookup only matches the nearest.
Ben_Hensel - thanks, works great until i input the date in A1 as the same date on Sheet2, again, i would need it to show me the next coming Name (following the date in A1)
Apologies both, my explanation may not have been tip top blurry eyes after sitting in-front of laptop all day
Kind Regards, galvinpaddy