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!