Index Match Functions with Ranged quantity lookups

[JMBurns578]

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.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[JMBurns578]

Thanks again! Got all the kinks out of my data and everything is working as it should!

 

[DanteAmor]

Again with pleasure. Thanks for the feedback