Using functions to correlate data
 

Hi there.

I want to use a function to reduce the workload in a spreadsheet by having
it automatically correlate data for me.

The layout is this.

The first coumn has dates.
The second column has the particular events happening on those dates.

I then have a second spreadsheet. What I want is to be able to enter any
particular date on that spreadsheet, and have the formula automatically enter
the event into a blank box.

I'd then also like to have it look up all of the people in attendance on
that date, and enter them into a set of rows beneath the date and event.

I realize this all sounds a little complicated, but I'm trying to set up
three months' worth of event programming, and it would simplify everything no
end!

Using functions to correlate data
 

Hi,

Where are all the people in attendance? Sheet1:

A B
1/1/2009 Kickoff
1/2/2009 Farewell for JT
1/5/2009 Seminar
....

And where do you want the people so show up on the sheet where you enter the
date? Sheet2:

A B
1/2/2009 Farewell for JT


--
Thanks,
Shane Devenshire


"Benjamin Searle" wrote:

Hi there.

I want to use a function to reduce the workload in a spreadsheet by having
it automatically correlate data for me.

The layout is this.

The first coumn has dates.
The second column has the particular events happening on those dates.

I then have a second spreadsheet. What I want is to be able to enter any
particular date on that spreadsheet, and have the formula automatically enter
the event into a blank box.

I'd then also like to have it look up all of the people in attendance on
that date, and enter them into a set of rows beneath the date and event.

I realize this all sounds a little complicated, but I'm trying to set up
three months' worth of event programming, and it would simplify everything no
end!

Using functions to correlate data
 

Check Help to learn about VLOOKUP then come back if you have problem using
it
Something like: =VLOOKUP(G5,Sheet2!A1:B6,2,FALSE)
G5 has the date to be found, the table is on Sheet2 in A1:B6

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Benjamin Searle" <Benjamin wrote in
message ...
Hi there.

I want to use a function to reduce the workload in a spreadsheet by having
it automatically correlate data for me.

The layout is this.

The first coumn has dates.
The second column has the particular events happening on those dates.

I then have a second spreadsheet. What I want is to be able to enter any
particular date on that spreadsheet, and have the formula automatically
enter
the event into a blank box.

I'd then also like to have it look up all of the people in attendance on
that date, and enter them into a set of rows beneath the date and event.

I realize this all sounds a little complicated, but I'm trying to set up
three months' worth of event programming, and it would simplify everything
no
end!