INDEX and MATCH Functions For Unusual Lookups

Topics: Lookup Formulas, a few Statistics functions, Goal Seek

 

 

Topics in this video:
1. INDEX and MATCH (00:10 min)
2. Lookup Left, 1-way vertical range lookup (00:32 min)
3. Lookup Low Bid, 1-way horizontal range lookup (04:41 min)
4. 2-way lookup to lookup discount rate (08:27 min)
5. Lookup Whole Row or Column to add monthly numbers (13:14 min)

Questions