vendredi 22 juillet 2016

Vlookup within an IfError statement tying two columns to one result

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