Merge data from two separate tables

[brownmre]

I want values from table two to be copied into table one where 2 cells from a
row in table 2 matches 2 cells in a row from table one. Examples: if b6
(table 1) equals a value in column b (table 2) and d6 (table 1) equals a
value in column d (table 2), then e6 (table 1) will equal value “aok†from
column d (table 2). Any ideas?


worksheet 1
a b c d e
1 code item# name SUBC plant
2 a12 1001 s1f 1 aok
3 a12 1002 s1f2 k bal
4 a12 1003 tex 1 bal
5 a14 1004 saf s aok
6 a14 1005 plc 1
7 a15 1006 wak 1 bal

worksheet 2
a b c d e
1 code item# name SUBC plant
2 a12 1001 s1f 1 bal
3 a12 1007 win k aok
4 a14 1005 plc 1 aok

 

[Fred Smith]

I would add a helper column that concatenates B and D (=b2&d2, copied down).
Then it's a simple Vlookup.

Regards,
Fred

 

[brownmre]

Can you explain - I am not familiar.

I would add a helper column that concatenates B and D (=b2&d2, copied down).
Then it's a simple Vlookup.

Regards,
Fred



.

 

[Fred Smith]

What do you need explained? Are you not familiar with concatenation (&) or
Vlookup or helper columns?

Regards,
Fred