Extract and list values from different sheets

Originally Posted by bower

Hello,

I am interested in extracting and listing values from different spreadsheets. The values should be grouped together according to the identifying information given in 3 columns (A-C), with the value given in column D.

As an example a sheet1 may contain the following in line 30:
A30=3099
B30=ABC 0.4
C30=KLM20
D30=45

Sheet2 in line 36:
A36=3099
B36=ABC 0.4
C36=KLM20
D36=40

Sheet 3 in line 25:
A25=3099
B25=ABC 0.4
C25=KLM20
D25=50

I am interested in extracting to a new sheet columns A-C (identifying information) and then listing the values (45, 40, 50...) in columns D, E, F....

Is there an easy way to do this?

Thank you,

Peter

please attach a sample file.

Originally Posted by bower

Here are two sample files attached. I am interested in being able to combine data from multiple files.

Peter

Hi
VLOOKUP formula may help.

see link below for its use.

http://www.contextures.com/xlFunctions02.html