Selecting rows from various sheets

[shav]

Hi all,
I have several sheets with a few columns in each. One colum
in each sheet has a unique value. Most of these unique values are th
same in each sheet but not all. Is there any way that I can set up
new sheet that will have the unique value in column 1 and th
corresponding column values frommeach sheet beside it. For example
Sheet 1
aa 1 1 1
bb 2 2 2
cc 3 3 3

Sheet 2
aa 4 4
cc 5 5

Result
aa 1 1 1 4 4
bb 2 2 2
cc 3 3 3 5 5

Thanks alot,
Sha

 

[Frank Kabel]

Hi
have a look at VLOOKUP for this. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm