IF/AND/HAS for 3 column references, 6 options
Based on the content above for reference only, the actual sheet screenshot below. I need a formula or help with a helper sheet/workflow, to bring back one of 6 results.
(above image) Tax Status Column is a dropdown with the 2 options shown, Bottling Location and Entity Columns are INDEX(COLLECT formulas (if it matters) pulling from another sheet.
(Actual Below) If Tax Status is Tax-Paid, Bottling LOCATION is Infinity Bottling, Entity is any of the 6, it enters the corresponding number from that entity into the TAX-PAID BOTTLING HOUSE PERMITS cell. I've created 2 reference formulas before, but this one is outside my ability. Appreciate any assistance.
Help Article Resources
Check out the Formula Handbook template!