Forum Discussion
Excel VLOOKUP with Multiple Criteria (Dynamic Price Tiers) to determine Markup Price
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 pric...
Hi,
Why are you using the function LOOKUP() ?
Could you please guide us which are the conditions/logic behind the calculation of the price tiers and the % rate? What is the expected result?
I believe it would be much easier to help you if you could attach a small sample document without sensitive data or at least share a screenshot of sample data.
- Hi, Agosto. Thanks for your interest to help. I did finally figure out the solution.
Thanks again.
