Hello all,
I've decided to ask since I couldn't find similar post about my issue. Would appreciate any help here.
Tasks:
Imagine that I have a spreadsheet w/ a list of products (pie's) and each pie has a batch # and is also categorized into A, B, C ...
As you can see from the attached spreadsheet, sometimes, the same product is not categorized.
I'd like to run a VLOOKUP on this sheet looking for the batch # in column 1, if there's a match then I'd like to return the "category" in column 2.
Take Blueberry pie, e.g. (in "Sheet1"), the first time VLOOKUP encounters this product in cell C3, the category is empty so I'd like VLOOKUP to return 0 or something similar AND continue searching the list (it should not stop there because there's another instance of Blueberry pie in cell C10. If the product is not on the list, then return N/A or something similar.
My approach appears to works so far (see "Sheet2") but I'd like to make the formula more robust by incorporating functions such as: ISBLANK, IFERROR, etc to make it bulletproof - so it catches every possible error or situation. Obviously, I've simplified the data provided but imagine if there were 5,000 different products on the list, e.g.
Does anyone have ideas on how to do this?
Bookmarks