Lookup Help.... (Please?)
Hi there, I have one sheet ('A') with a range of dates (dd/mm/yyyy) in row 3.
In column A there are some times and the cells from column B onwards, will
have values in pertaining to the times on different dates.
I want to create a second sheet lists the same times and when the user
enters the date that they want in a cell, the sheet can return the values for
each of the times for that specific date.
I have played around with look-ups and trying to name the cell where the
user inputs the date, but no joy.... Any help greatly appreciated!
|