I have a table with four columns: Price Tier, Min, Max, % rate. I want to use a vlookup in excel to determine the appropriate % rate based on the input from the user, and then compute the markup price (dynamic price tiers).

I have tried these formulae with no success:

1. To get the price tiers, I used: LOOKUP(2,1/((H3>=H6:H17)*(H3<=I6:I17)),G6:G17)

2. To get the % rate, I used: =LOOKUP(I3,tiers,customers)

I would appreciate any help.

Also, how do I use mins and maxes in excel? I don’t mean minimum and maximum. It puzzles me that I can’t even get a hint about it in excel.

Again, I would appreciate your help in solving this problem.

​I have a table with four columns: Price Tier, Min, Max, % rate. I want to use a vlookup in excel to determine the appropriate % rate based on the input from the user, and then compute the markup price (dynamic price tiers). I have tried these formulae with no success: 1. To get the price tiers, I used: LOOKUP(2,1/((H3>=H6:H17)*(H3<=I6:I17)),G6:G17)2. To get the % rate, I used: =LOOKUP(I3,tiers,customers) I would appreciate any help. Also, how do I use mins and maxes in excel? I don’t mean minimum and maximum. It puzzles me that I can’t even get a hint about it in excel. Again, I would appreciate your help in solving this problem.  Read More

​