Matching from 2 columns between 2 workbooks

[dougc]

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

 

[zzydhf]

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
	A	B	C	D	E	F	G	H	I
1	de	344	de344	value 2	<< from c>
2	gf	43543	gf43543	value 1	<<>
3	gjk	345	gjk345	value 1	<<>
4	dh	345	dh345	value 4	<<>
5	m,	345	m,345	value 5	<<>
6	gh	23	gh23	value 6	<<>
7	dfgh	23	dfgh23	value 7	<<>
8	dgh	455	dgh455	value 8	<<>
9
10
11	Below is sheet2's data
12
13
14	m,	345	value 5	m,345
15	gjk	345	value 1	gjk345
16	gh	23	value 6	gh23
17	gf	43543	value 1	gf43543
18	dh	345	value 4	dh345
19	dgh	455	value 8	dgh455
20	dfgh	23	value 7	dfgh23
21	de	344	value 2	de344
...

HTH (Hope This Helps)

 

[PaddyD]

This can be accomplished without concatenating the 2 cells into a single value. see, eg:

http://www.mrexcel.com/board/viewtopic.php?topic=21288&forum=2

for som info on doing multikey lookups. Post back if you can't adapt it to your situation.

paddy

 

[dougc]

Hi Paddy,

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

Best regards,
dougc