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...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?