In Sheet2,
Assuming data starts in row2 down, and you want to extract it into col D
In D2:
=IF(ISNA(MATCH(G2,Sheet1!G:G,0)),"",INDEX(Sheet1!D :D,MATCH(G2,Sheet1!G:G,0)))
Copy D2 down to extract data from Sheet1's col D* for the matched values in
col G.
*that's the col specified in this part: .. INDEX(Sheet1!D:D
The above will do the job even if the order of the match values in col G in
both Sheet1/2 are different
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"israel" wrote:
I have now an urgent request for help. I have 2 spreadsheets each 10
columns and 500 rows. Column "G" is identical all other columns have
different information. I have to combine the two spreadsheets.
Rather I have to insert column "D" from spreadsheet 1 to spreadsheet 2.
Column "G" is indentical in both spreadsheets.