| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a good program for excel to combine, compare, and edit bo | Excel Discussion (Misc queries) | |||
| How do I combine multiple Excel sheets? | Excel Discussion (Misc queries) | |||
| Combine excel sheets in layers | Excel Discussion (Misc queries) | |||
| How do I combine several sheets into one document in Excel? | Excel Discussion (Misc queries) | |||
| Combine cell totals from 5 sheets into summary in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
