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

ExcelIsFun

  • Currently 0.00/5
  • 1
  • 2
  • 3
  • 4
  • 5
Rating: 0.0 out of 0 votes
Comments (0)

Refresh page if video doesn't load!!! Download Video Excel Magic Trick 838: Two Way Lookup, then Multiply To Get Commission Earned

You need to have the Flash Player installed and a browser with JavaScript support.


Lights off
Sorry, your favorites list is FULL.

Link to this video

Description

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

Tags



Comments

Be the first to comment

Sign in or sign up to post comments.
Artist: ExcelIsFun
Video title: Excel Magic Trick 838: Two Way Lookup, then Multiply To Get Commission Earned
Category: Education
Views: 959
Submitted by: admin