Table1 has part #s A01, A02, A06 and related pricing of $12.50, $1.23,
and $7.48.
Table2 has part #s A02, A06, A10, A15 and pricing of $8.05, $2.03,
$5.17, $6.20

How can I merge these two tables to wind up with a combined table that
looks like this:

Part # Price 1 Price 2
--------- ------------ ------------
A01 12.50
A02 1.23 8.05
A06 7.48 2.03
A10 5.17
A15 6.20

Thanks in advance!

You can use a Vlookup formula

If the merged Table was in columns A1:C3 then in cell C3 put th following
formula

=vlookup(A1,$D$1:$E$100,2) adn copy down colun

D1:E100 is the table with Price 2 where the part number is in Column D and
the Price is in Column E.

"jvbelg" wrote:

Table1 has part #s A01, A02, A06 and related pricing of $12.50, $1.23,
and $7.48.
Table2 has part #s A02, A06, A10, A15 and pricing of $8.05, $2.03,
$5.17, $6.20

How can I merge these two tables to wind up with a combined table that
looks like this:

Part # Price 1 Price 2
--------- ------------ ------------
A01 12.50
A02 1.23 8.05
A06 7.48 2.03
A10 5.17
A15 6.20

Thanks in advance!

Joel,

The problem is not to put the prices in there - that would indeed
nicely work with the vlookup as you mention.
The challenge is to merge the part numbers.

Cheers - Jan


On Sep 17, 11:51*am, Joel wrote:
You can use a Vlookup formula

If the merged Table was in columns A1:C3 then in cell C3 put th following
formula

=vlookup(A1,$D$1:$E$100,2) adn copy down colun

D1:E100 is the table with Price 2 where the part number is in Column D and
the Price is in Column E.



"jvbelg" wrote:
Table1 has part #s A01, A02, A06 and related pricing of $12.50, $1.23,
and $7.48.
Table2 has part #s A02, A06, A10, A15 and pricing of $8.05, $2.03,
$5.17, $6.20

How can I merge these two tables to wind up with a combined table that
looks like this:

Part # * * *Price 1 * * *Price 2
--------- * * ------------ * * ------------
A01 * * * * 12.50
A02 * * * * *1.23 * * * * *8.05
A06 * * * * *7.48 * * * * *2.03
A10 * * * * * * * * * * * * *5.17
A15 * * * * * * * * * * * * *6.20

Thanks in advance!- Hide quoted text -

- Show quoted text -

There are VBA way of doig this. If you want to avoid VBA you can get a
unique set of values using Data - Filter - Advance filter - Unique records.
Copy the two sets of part number to a new section of the worksheet. Then use
advance filter to get a unique list of part numbers. Now use Vlokup to fill
inthe new table with prices from both original lists.

"jvbelg" wrote:

Joel,

The problem is not to put the prices in there - that would indeed
nicely work with the vlookup as you mention.
The challenge is to merge the part numbers.

Cheers - Jan


On Sep 17, 11:51 am, Joel wrote:
You can use a Vlookup formula

If the merged Table was in columns A1:C3 then in cell C3 put th following
formula

=vlookup(A1,$D$1:$E$100,2) adn copy down colun

D1:E100 is the table with Price 2 where the part number is in Column D and
the Price is in Column E.



"jvbelg" wrote:
Table1 has part #s A01, A02, A06 and related pricing of $12.50, $1.23,
and $7.48.
Table2 has part #s A02, A06, A10, A15 and pricing of $8.05, $2.03,
$5.17, $6.20

How can I merge these two tables to wind up with a combined table that
looks like this:

Part # Price 1 Price 2
--------- ------------ ------------
A01 12.50
A02 1.23 8.05
A06 7.48 2.03
A10 5.17
A15 6.20

Thanks in advance!- Hide quoted text -

- Show quoted text -