View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MeMe MeMe is offline
external usenet poster
 
Posts: 18
Default Looking up values in multiple rows

Hi there,

I need to have a vlookup or something that works across rows.

For example, I have column A representing time, with A1 through to Axxxx
with each cell showing a time for a specific date. So for June 1 we would see
the times 08:00, 08:30, 09:00, etc. Then for June 2 we would see the times
08:00, 08:30, 09:00, etc.. For the entire month these same times are noted.
Column C is the column that has the data that I want, but I only want a
specific time.

How do I set this up so that my formula gives me the column C data for 12:30
for every day in June.

Thanks,
Marie