Main Profile

At A Glance

Mr Excel & excelisfun Trick 96: LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type)

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmSee 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.
Length: 08:05

Contact

Questions about Mr Excel & excelisfun Trick 96: LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type)

Want more info about Mr Excel & excelisfun Trick 96: LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question