Question: how to calculate percentage using vlookup?
Answer: Step 1 - Identify relative position of category in array. MATCH(F11,{"A","B"},0) ...  Step 2 - Choose cell range. ...  Step 3 - Use cell range in VLOOKUP function and return corresponding discount percentage.