Hello. I'm having difficulty creating this formula. I need to find a value that falls on or between another value, then returns another value. I've tried IF statements and INDEX/MATCH formulas, and ultimately i think i need both. Here is a clip of what i'm working with. Say I have 1,200 pcs of an item. My price break falls along this table: 500, 750, 1000, 1500 and the value I need to return is the cost of that quantity for that range. Please help! Thank you.