Looking up values in multiple rows
One way...
Assuming your dates/times are true Excel dates/times...
Enter the first day of the month for the date/time you want to lookup in a
cell:
E1 = 6/1/2009 12:30 PM
Enter this formula in F1 and copy down as needed:
=INDEX(C:C,MATCH(E$1+ROWS(F$1:F1)-1,A:A,0))
--
Biff
Microsoft Excel MVP
"MeMe" wrote in message
...
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
|