Database-type joining of spreadsheets

[jim]

I have several worksheets describing college students; in
each spreadsheet one column is the Student's Social
Security Number. My question is: how can I "join" these
worksheets together into a single NEW spreadsheet which
has one row for each student that is represented by at
least one of the input spreadsheets.

I would rather NOT port the spreadsheets into Access and
do table joins there.

Thanks for your help.

 

[Bernard Liengme]

Read Help on VLOOKUP and come back if you need more