JMBurns578
New Member
- Joined
- Jun 22, 2016
- Messages
- 5
I know how to do index match and I know how to do vlookups to find a value within a quantity range. I cannot seem to get it to work doing an index match function pulling a value from a table within a range. See attached image.
I want to be able to type a quantity, any number 1-1000, into the qty cell M5 and have the price per unit pulled from the table on the left show up in cell N5.
I want to be able to type a quantity, any number 1-1000, into the qty cell M5 and have the price per unit pulled from the table on the left show up in cell N5.