I am building a schedule of items from a report that comes from a custodian. Recently the custodian changed its report format and my input sheet needs a small expansion. I need my code to be able to classify items by either a product code or a product description. My work-in-process code is as follows:
=IFERROR(VLOOKUP(J4,'Product Codes'!A5:C20,3,FALSE),"Needs Review")
The formula below was the original that worked, however,
=IFERROR(VLOOKUP(J5,'Product Codes'!A:B,2,FALSE),"Needs Review")
it does not cover the additional possibilities that can tie A, or now B, to C (classification type) with the introduction of the new reporting format. I now need a formula that can attribute either A or B (new "B" being the product descriptions) to the value shown in column C. Thank you for any help that can be provided!
Aucun commentaire:
Enregistrer un commentaire