try datafilterautofilter

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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