Excel Magic Trick 838: Two Way Lookup, then Multiply To Get Commission Earned

ExcelIsFun
453K
10,518 views

Transcript

The interactive transcript could not be loaded.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Dec 15, 2011

Download file: https://people.highline.edu/mgirvin/E...
See two methods to calculate commissions when the lookup table involves Two Way Lookup:
1. VLOOKUP & MATCH function formula
2. INDEX and 2 MATCH functions formula

  • Category

  • License

    • Standard YouTube License
Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to