| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two sheet of data -- cost price increases
I have 3 Sheets of data.
the first on has two columns NEW COST PRICES SHEET1 A2 TO B9251 A B PART NUMBER COST SHEET2 A2:C18051 CURRENT COST AND SELL PRICES A B C PART NUMBER COST SELLING PRICE SHEET3 A2:B20500 A PART NUMBER I NEED TO CREATE A FORMULA TO COMPARE THE NEW COST PRICES SHEET1 WITH THE CURRENT COST PRICES SHEET2 AND SHOW THE PERCENTAGE DIFF. I NEED TO MATCH THE EXACT PART NUMBER FROM COLUMN A ON SHEET 3 I NEED TO COMPARE THE PART NUMBER IN COLUMN A AND MATCH IT EXACTLY TO THE PARTS IN SHEET2 AND SHOW THE COST PRICES (COLUMN B) OR 0 VALUE IF NO MATCH |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tracking Cost Price from Different Sheets | Excel Discussion (Misc queries) | |||
| Cost to Retail Price Formula - some help pse | Excel Worksheet Functions | |||
| Converting cost price to retail in vast array | Excel Worksheet Functions | |||
| annual increases in price lists | Excel Discussion (Misc queries) | |||
| formula for cost as percentage of sale price | New Users to Excel | |||
Threaded Mode
