I a cell on Ship A's sheet, fill a column of formulas like this

=VLOOKUP(A2,'Ship B'!A:B,2,FALSE)

where A2 has the part number.

Then select that column of formulas, select Edit Go-To Special.... Formulas, Errors, click OK then
press Delete. That will get rid of the formula from rows that don't have a match.

HTH,
Bernie
MS Excel MVP


"Reebis" wrote in message
...
Hello,

I have 2 different sheets, 1 for ship A and 1 for ship B.
Both these ships have part numbers and prices associated with them. Lets
say Column A has the part numbers and Column B has the prices associated with
these part numbers. My task is to compare the 2 sheets, find part numbers
that they both have in common and insert the price from Ship B into Ship A's
sheet.

I am thinking that this will be some sort of Macro, but I dont have really
any experience with these. If someone has a different approach, that would
be great.

Thanks