Hi guys, I got a question and Fav to ask

I have a sheet that has a series of Dates being the Mondays dates through
the year next to each date is a listing of 4 names.

EG:
Date A B C D
11-Jun Bob Frank Gareth Trevor
18-Jun Trevor Bob Frank Gareth

What i want to do is this.

I have a sheet that has the Current date =today() {dd-mmm} i want it to take
that value and find it so should the date be 13-JUN how do i get it to return
the value from say A3 because that date falls into the 11-Jun section?

So basically to clarify i want to do a Vlookup on a name that falls on the
Mondays date when compared to todays date and then return the A,B,C or D at
the top. Can this be done? and how would i do it?

Thanks in advance for any assist.