on tab "AS Data" i have a table Y through AB
Y = Names
Z = Dates
AA = Start Time
AB = End Time
on tab Report I have a drop down in cell a2 with names and column A has dates from 12-29-2016 to 3-23-2017.
I need a formula that vlookups the name in cell a2, matches the date on tab Report and returns the time in column AA with that criteria
Bookmarks