Dueling Excel 96


LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type)

DESCRIPTION

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.

WORKBOOKS