See how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month. See an amazing formula from Dave Patton at the Mr Excel Message Board. Download file: flightline.highline.edu
http://www.youtube.com/watch?v=bfUIwZ7apkk&hl=en
Showing posts with label Lookup. Show all posts
Showing posts with label Lookup. Show all posts
Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Trouble
See how to use the INDIRECT, TEXT, SUBSTITUTE, Named Ranges, Create Name From Selection, and Space Operator to do a two way lookup when the named ranges contain dates. Then see a much better method using VLOOKUP and MATCH functions. See this video: Excel Name Trick #7: INDIRECT function, Names and LOOKUP
http://www.youtube.com/watch?v=eMB_8VMmYmc&hl=en
http://www.youtube.com/watch?v=eMB_8VMmYmc&hl=en
Subscribe to:
Posts (Atom)
