I get a data dump from my ERP system that is not customizable so it's really all I have to work with. I'm a bit unfamiliar with IF statements and i'm assuming that's what I will need.
My data dump includes titles Work order, part number, scrap code, and quantity scrapped. Each like has all sets of titles if that makes sense. So there could be multiple rows of data for the same work order and part number depending on what scrape code, how much scrap, etc.
What i'm trying to do id I created a separate tab that paired part number with work order number so i did not have multiples. And i threw all of the scrap codes in columns across. What i want to do is lookup how much scrap was for each work order and put it in the appropriate column so i can total at the end and get scrap percentage if that makes sense??
Please help
My data dump includes titles Work order, part number, scrap code, and quantity scrapped. Each like has all sets of titles if that makes sense. So there could be multiple rows of data for the same work order and part number depending on what scrape code, how much scrap, etc.
What i'm trying to do id I created a separate tab that paired part number with work order number so i did not have multiples. And i threw all of the scrap codes in columns across. What i want to do is lookup how much scrap was for each work order and put it in the appropriate column so i can total at the end and get scrap percentage if that makes sense??
Please help
