Loading...

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

10,518 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

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

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...