Linking THREE worksheets

[TomTX]

How can I link the attached 3 worksheets in a NEW worksheet, where b
all of the contents of three worksheets are linked in the new workshee
using the same format.

These three worksheets contains the data by year (i.e. 1998, 1999, an
2000) for several individuals. Note some of these individuals may b
appearing in all three worksheets. As such, is it possible to see th
columns (Set A and Set B) of respective worksheet shown in the NE
worksheet with the listing of people name?

I tried using the V/Lookup formulas, but it does not combine the data.

I would greatly appreciate any help I can obtain from the user forum.

Thanks

TomT

+----------------------------------------------------------------
| Attachment filename: people 3 yr temp.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=361002
+----------------------------------------------------------------

 

[JR]

Tom,

First, I think your data in 98,99,00 need to be sorted
ascending by name (you'll have to be sure to get all
the names in order onto your "newworksheet"). Then the
formula:
=IF(ISERROR(VLOOKUP(A2,'98'!A1:C47,2)),"-",VLOOKUP
(A2,'98'!A1:C47,2)) should work for the 6 columns you
have in "newworksheet"- you need to modify the 98 to
99 and 100 for the appropriate year columns, and modify
the
",2)" to ",3)" for the "B" columns. Finally filldown
all six columns to complete.
jr