Matching from 2 columns between 2 workbooks

dougc

New Member
Joined
Oct 24, 2002
Messages
6
I am trying to do the follwoing wihtout using VB in Excel. I am not familiar with VB so I am wondering if anyone would know how to accomplish this using Excel functions.

If a cell in column A of workbook 1 matches a cell in column A of workbook 2 AND a cell from column B in the same row as the cell from column A match of Workbook 1 matches a cell from column B in same row as the column A match of Workbook 2, I need to bring the value from column C of workbook 2 to Column C in workbook 1 on the same row where that had the matches for column A and column B.

For example, if A2 of workbook 1 matches A9 of workbook 2 and B2 of workbook 1 matches B9 of workbook 2 then I need to bring the value in C9 of workbook 2 into C2 of workbook 1. If any one of the four rows in this example were not the same, column C of the row in workbook 1 would remain empty.

In case it matters, values in Columns A and B of both worksheets can be any combination of letters and numbers. Values in Column C fo workbook 2 would be formated for currency or accounting.

Thanks,
dougc
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

zzydhf

Board Regular
Joined
Apr 10, 2002
Messages
236
how about in each sheet, make a column of both cells. in sheet 1 c1: =a1&b1 copy down

in sheet 2 d1 = a1&b1 copy down.
now match sheet1 c1 to sheet 2 d1:d100 (or whatever)

eg.
Book2
ABCDEFGHI
1de344de344value 2<< from c>
2gf43543gf43543value 1<<>
3gjk345gjk345value 1<<>
4dh345dh345value 4<<>
5m,345m,345value 5<<>
6gh23gh23value 6<<>
7dfgh23dfgh23value 7<<>
8dgh455dgh455value 8<<>
9
10
11Below is sheet2's data
12
13
14m,345value 5m,345
15gjk345value 1gjk345
16gh23value 6gh23
17gf43543value 1gf43543
18dh345value 4dh345
19dgh455value 8dgh455
20dfgh23value 7dfgh23
21de344value 2de344
...


HTH (Hope This Helps)
 

dougc

New Member
Joined
Oct 24, 2002
Messages
6
Hi Paddy,

Thank you very, very much. Your solution worked excellently.

Best regards,
dougc
 

Forum statistics

Threads
1,144,449
Messages
5,724,414
Members
422,552
Latest member
Ajit Kumar_1982

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top