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

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
5,703
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jan 26, 2012

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
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.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (4)

Sign In or Sign Up now to post a comment!
  • @krn14242 , you are welcome!

  • Thanks mike and bill, Mike had less keystrokes, maybe he should get the point.

  • @0selam , I am glad that you like it!

  • great!

    

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more