I could, but I need the information from the 4 sheets in another worksheet. I
had thought that I could use a VLOOKUP that allowed for multiple instances of
the same lookup value over the course of 2 months. Unfortunately, the lookup
only works for the first instance of the lookup value, then I don't know how
to modify the formula so that it can do the rest of the spreadsheet.

Suggestions?

"Gord Dibben" wrote:

Did you try Don's suggestion?

AutoFilter for month of June then filter for 12:30


Gord Dibben MS Excel MVP

On Thu, 18 Jun 2009 11:25:01 -0700, MeMe
wrote:

Can I send it to you?

"T. Valko" wrote:

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