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!