S
SD
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
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