Highline Excel 2013 Class Video 21

INDEX and MATCH Functions For Unusual Lookups 4 Examples

TOPICS IN THIS VIDEO

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