['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.']