Question: how to calculate percentage in 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.