vahju
10-03-2005, 08:40 AM
Scenario:
Two spreadsheets. Both contain similar data (alphanumeric characters) but not exactly the same. The data in First three columns in both spreadsheets match. Need to copy over data in Sheet2 to Sheet1 in corresponding row based on criteria below. Each spreadsheet contains a couple hundred rows.
Problem:
Need to compare cells A1, B1, and C1 in both spreadsheets. If all three cells match in the same row in both spreadsheets then copy cell D1 from sheet2 into D1 of sheet1.
Logic (pseudo code):
If Sheet1.A1 equal to Sheet2.A1 and
Sheet2.B1 equal to Sheet2.B1 and
Sheet2.C1 equal to Sheet2.C1 then
Copy Sheet2.D1 to Sheet1.D1
Else
Leave blank.
I believe once the formula is created I should be able to fill it all the way down to get my results. I did some research and think the Index combined with Match function would work but I have no experience with these functions.
Any help would be appreciated.
Two spreadsheets. Both contain similar data (alphanumeric characters) but not exactly the same. The data in First three columns in both spreadsheets match. Need to copy over data in Sheet2 to Sheet1 in corresponding row based on criteria below. Each spreadsheet contains a couple hundred rows.
Problem:
Need to compare cells A1, B1, and C1 in both spreadsheets. If all three cells match in the same row in both spreadsheets then copy cell D1 from sheet2 into D1 of sheet1.
Logic (pseudo code):
If Sheet1.A1 equal to Sheet2.A1 and
Sheet2.B1 equal to Sheet2.B1 and
Sheet2.C1 equal to Sheet2.C1 then
Copy Sheet2.D1 to Sheet1.D1
Else
Leave blank.
I believe once the formula is created I should be able to fill it all the way down to get my results. I did some research and think the Index combined with Match function would work but I have no experience with these functions.
Any help would be appreciated.