View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy Andy is offline
external usenet poster
 
Posts: 414
Default 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!