Excel Magic Trick 1481

Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too

DESCRIPTION

In this video learn how to how to perform lookup from multiple tables. Learn two methods: 1) VLOOKUP and SWITCH Function or 2) VLOOKUP and INDIRECT Function with Defined Names.
(00:01) Introduction
(01:30) VLOOKUP and SWITCH Function (New Excel 2016 Office 365 Function)
(07:20) VLOOKUP and INDIRECT Function with Defined Names.
(11:06) Summary

WORKBOOKS

Download “Excel Magic Trick 1481-1490” Excel-Magic-Trick-1481-1490.zip – Downloaded 39 times – 2 MB







Be the first to comment

Leave a Reply