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!

Hi Andy,

Have you tried HLOOKUP. Horizontal lookup versus vertical.

Data validation, and named ranges would help too.

if in row 3 you have dates in ascending order, like 01/01/04, 18/05/04, and
10/01/04. Then in row 4 10:00 am, 11:00 am. and 12:00 pm.

In the cell that you want the user to select a date: Data-validation-list
Then select your range, or use a named range.

In another cell (I'm assuming one down or to the right, you could type in an
equation that looks something like:

=HLOOKUP(A7,A3:G4,2)

Where A7 is the cell that I chose for the user to select the date. I used
data validation using the range A3: G3.

HTH

BigPig

"Andy" wrote:

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!