Dueling Excel 96

LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type)


See Mr Excel and excelisfun use two methods to lookup a column of sales amounts in order to create a single cell formula that will add all the bonuses. Learn many tricks about the LOOKUP function, and also how to use SUM and SUMPRODUCT. Array Formulas.