Merge data from 2 sheets into 1

I need a formula that will search sheet 1 column A for all part numbers, return them into A1 to A-whatever on sheet 3.

Then look up the price of that part number on sheet 1 column B and return in to B2 to B-whatever on sheet 3.

Finally, look up the part number that is now in A1 on sheet 3 and search sheet 2 for it, when and if its found return the weight of that part in C3 on sheet 3.

Basicly end up with sheet 3 showing the part number, price and weight.

See example if needed.

Thanks all. BVG

Hi there,

Let me know if the attached meets your needs or if you have any issues with it.

HTH

Robert