Here is our scenario. We have at database of purchases to which we need to apply a discount. The discount applied depends on the product category: A, B or C and the quantity purchased. The lookup tables for each category are on separate sheets as shown below.
70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!