Excel fundi's please help.
I have an Excel pricelist worksheet (.xls Excel 2003, 300 lines) with the following columns:
Code Price1 Price2 Price3
I also have another worksheet(.xls Excel 2003, 2000 lines) with the following columns:
Code Description

I want to modify first worksheet or create a third worksheet that will have:
Code Description Price1 Price2 Price3

Copy and paste or sorting will not work as different number of lines.
All codes in first worksheet are in second worksheet.

I would like excel to look for same code in different worksheet and pull the description .
Hope this makes sense. Any ideas would be appreciated