Merge data from two separate tables
 

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

Merge data from two separate tables
 

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

Regards,
Fred

"brownmre" wrote in message
...
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

Merge data from two separate tables
 

Can you explain - I am not familiar.

"Fred Smith" wrote:

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

Regards,
Fred

"brownmre" wrote in message
...
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



.

Merge data from two separate tables
 

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

Regards,
Fred

"brownmre" wrote in message
...
Can you explain - I am not familiar.

"Fred Smith" wrote:

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

Regards,
Fred

"brownmre" wrote in message
...
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



.