B5rocksass
Board Regular
- Joined
- Jan 10, 2017
- Messages
- 56
- Office Version
- 2016
- Platform
- Windows
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.
ITEM | 500 | 750 | 1000 | 1500 |
CARD HOLDERS | 1.29 | 1.22 | 1.19 | 1.15 |
TOTE BAGS | 2.47 | 2.4 | 2.37 | 2.33 |