Hi everyone,

Purpose: create classroom roster between one Excel spreadsheet as data
source and another excel sheet.

I know how to use one excel spreadsheet as a data source to merge with
another word document; however, by using this method, I found that the link
between the files keep dropping from time to time, especially when the folder
has been moved around.
I'm thinking of creating the same layout of the Word document in another
Excel spreadsheet and somehow "LINK" the data source and the other
spreadsheet together, but I'm not sure how, or whether this is even possible.
I'm thinking of using Vlookup or Hlookup, but this function only return one
result and I'd like the function to return multiple result based on the look
up criteria.

Please find my data source layout below:
First Name | Last Name | Days | Classroom | DoB ...

As you may notice that "Classroom" column will contain repeated information,
and if I choose this as the look up criteria in Vlookup or Hlookup, the
function only return one result. And that's not the whole roster for that
particular classroom.

Is there anyone who have done this sort of thing before?
Is this possible to do in Excel? I'm using Excel 2003.

Thank you,
Neon520