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

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

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

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

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

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

You can upload your file (with size restrictions) or a smaller sample file
to a free file host then post a link to the file. Then anyone that's
interested can look at the file.

I use this free file host often:

http://tinyurl.com/24xfnt

It's a French site that's been translated to English.

--
Biff
Microsoft Excel MVP


"MeMe" wrote in message
...
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

I posted it, but have never used the site.

Am welcoming ideas. I guess I just wait and see.

Thanks,

Marie

"T. Valko" wrote:

You can upload your file (with size restrictions) or a smaller sample file
to a free file host then post a link to the file. Then anyone that's
interested can look at the file.

I use this free file host often:

http://tinyurl.com/24xfnt

It's a French site that's been translated to English.

--
Biff
Microsoft Excel MVP


"MeMe" wrote in message
...
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

You didn't post the link!

--
Biff
Microsoft Excel MVP


"MeMe" wrote in message
...
I posted it, but have never used the site.

Am welcoming ideas. I guess I just wait and see.

Thanks,

Marie

"T. Valko" wrote:

You can upload your file (with size restrictions) or a smaller sample
file
to a free file host then post a link to the file. Then anyone that's
interested can look at the file.

I use this free file host often:

http://tinyurl.com/24xfnt

It's a French site that's been translated to English.

--
Biff
Microsoft Excel MVP


"MeMe" wrote in message
...
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