Lookup Help.... (Please?)

[Guest]

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!

 

[Guest]

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