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 -