Purp,

The join is usually accomplished in Excel with a VLOOKUP for each field. But I'm not sure
why you have student names in one table and student addresses in another. You'd not
normally do that in Access either, unless maybe there's confidential stuff in one table or
the other. Maybe we need to know more. At any rate, the VLOOKUP can find the row you want
(the lookup colum must be on the left of the cell to be retrieved, and the values must be
unique). You may have to give us an example of how your data is laid out.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"PurpleMel" wrote in message
...
I have two worksheets in same workbook. W1 has student ID and other stuff
about students, W2 has addresses for these students.
I want to know if there is an easy/straightforward way to join these.
I have previously done this using the join table function in Access but am
writing procedures for someone else to follow and am looking for a less
clumsy way to do this.
nb: There are some multiple addresses for students and some students dont
have a known address.