I have one worksheet with data on 2 sheets. I need to match up the
product id and and copy the value from the 2nd sheet. I have one
sheet that has the product id, description and qty. The second has
the product id and the price. I would like to have the product id,
description, qty and price on one sheet.

Ex:
Sheet 1
Product id | Description | Qty
ic402 | Candy | 5
ic502 | Oil | 10

Sheet 2
Product id | Price
ic402 | $5.00
ic502 | $10.00

Would LOVE!
Product id | Description | Qty | Price
ic402 | Candy | 5 | $5.00
ic502 | Oil | 10 | $10.00

If anyone could help with a formula.

ps: I have more rows in sheet 2 than sheet 1. Sheet 2 has the price
of all items. Sheet 1 only has what is in stock.

Thanks!
Jason