VLOOKUP Multiple Sheets Names Using the INDIRECT Function
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. We are going to achieve this using a… Read More »VLOOKUP Multiple Sheets Names Using the INDIRECT Function