Hi,
I'm having trouble wrapping my head around a seemingly simple ask, and can't get any iteration of my index match formulas with multiple criteria to work.
See attached workbook for more details, but basically what I need my formula to do is first evaluate the component type in each cell (component types are "BRE", "Form", "Insert", and "OE"), and then within each component type, return a different % of acceptable overs for each component type, depending on the range of quantity ordered. (i.e. if Component Type = "BRE", and Quantity is b/t 0 and 10,000, return a value of 5%, if Component Type = "BRE", and Quantity is b/t 10,001 and 25,000 return a value of 3%, and so on.
Any help is greatly appreciated, and if there's a similar thread that already exists on the forum I apologize, but I was unable to find anything and am at my wit's end on this one.
Thanks very much,
Kevin
Bookmarks