Excel Magic Trick 1316

VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE?

DESCRIPTION

See how to use VLOOKUP when there are multiple Lookup Tables with these methods:
(00:15) Problem Set up
(01:48) IF Function
(05:57) IFS Function (Excel 2016 Insider Program) (Formula from XLarium at YouTube)
(08:47) SWITCH Function (Excel 2016 Insider Program)
(11:26) Names Ranges & INDIRECT Function?
(15:15) Summary

WORKBOOKS

Download “Excel Magic Trick 1301-1320” Excel-Magic-Trick-1301-1320.zip – Downloaded 337 times – 285 KB




Be the first to comment

Leave a Reply