Index/Match - Dynamic Index Range with Hlookup

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi Wassim and welcome to the forum,

I think your formula looks better
INDEX(HLOOKUP($C$8,H2:MT6,5,0)&3&":"&HLOOKUP($D$8,H2:MT6,5,0)&3,MATCH....
to
INDEX(HLOOKUP($C$8,H2:MT6,5,0)& "3" &":"& HLOOKUP($D$8,H2:MT6,5,0) &"3",MATCH....

Without a full formula or the workbook attached it is hard for us to check.

Volume Discount.xlsx

Thank you for your quick replies. Here is what I want to do:

I am setting up a price structure for volume discounts. I have 4 brackets on the left with the respective price. I want the formula in D25 to show me the break even point by telling me, at which number of orders the customer would automatically buy more products in order to get into the next bracket, which means more product for the same price. I want to make it as dynamic as possible by being able to adjust the price for the brackets and have the formula show me the new Break Even Point, or I want to be able to change the min and max unit amount in the brackets with it still automatically showing me the BEP.

Hope this helps, thanks again!