Highline Excel 2013 Class Video 21

INDEX and MATCH Functions For Unusual Lookups 4 Examples

DESCRIPTION

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.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 47 times – 21 MB




Be the first to comment

Leave a Reply