Hey Guys,
I'm having an issue with a formula. I have 4 main fields.. Part number, work order number, scrap code, and scrap. I have a separate sheet setup with part number and work order in the rows and scrap codes going across. I have already setup a vlookup to look up how many pieces of scrap per code.. but the problem is that it's only looking at the first piece of data listed for that work order number. I have formula currently setup as
IF(VLOOKUP(WORK ORDER NUMBER, SET OF DATA, SCRAP CODE COLUMN, FALSE)="SCRAP CODE", VLOOKUP(WORK ORDER NUMBER, SET OF DATA, AMOUNT OF SCRAP COLUMN< FALSE))
Any suggestions on what i should do? If there are multiple scrap codes for the same work order i'm done with this current formula. ANy help for this newbie is appreciated.
I'm having an issue with a formula. I have 4 main fields.. Part number, work order number, scrap code, and scrap. I have a separate sheet setup with part number and work order in the rows and scrap codes going across. I have already setup a vlookup to look up how many pieces of scrap per code.. but the problem is that it's only looking at the first piece of data listed for that work order number. I have formula currently setup as
IF(VLOOKUP(WORK ORDER NUMBER, SET OF DATA, SCRAP CODE COLUMN, FALSE)="SCRAP CODE", VLOOKUP(WORK ORDER NUMBER, SET OF DATA, AMOUNT OF SCRAP COLUMN< FALSE))
Any suggestions on what i should do? If there are multiple scrap codes for the same work order i'm done with this current formula. ANy help for this newbie is appreciated.