Compare to two sheets in one excel file to evaluate and combine whereidentical.
 

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

Compare to two sheets in one excel file to evaluate and combine where identical.
 

Something like this perhaps:
=VLOOKUP(A2,Sheet2!A2:B21,2,FALSE)

This formula goes in the first sheet in the first cell in which you want to
price. Drag the formula down as far as your data goes. This formula assumes
your data in Sheet1 starts in A2 with ID in Column A. It also assumes that
your data in Sheet2 starts in A2 with ID in Column A and Price in Column B.
Your data range in Sheet2 is assumed as A2:B21. Change all these to suit.
HTH Otto

wrote in message
...
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