I'm wanting to find a price, based of off a type and range.
For instance, here is a graph showing how much a specific fruit costs based on the amount purchased or type:
Here is what the worksheet would look like (TOP) and what the expect result would be (BOTTOM):
I'm having an issue figuring out how to use a criteria and also a range.
If "Regular"- determine range and determine pricing
If "Organic" or "Import" - use set pricing
I tried using INDEX MATCH but am unable to figure out how exactly to work this. Any help on this would be greatly appreciated. Thanks!
0\-\1\5\0
for 85-150. – user4039065