Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE?

excelisfun 101,209 8 years ago

Video Not Working? Fix It Now

Download Excel Files: Start File: https://excelisfun.net/files/EMT1316-Start.xlsx Finish File: https://excelisfun.net/files/EMT1316-Finished.xlsx Home page: https://excelisfun.net/ See how to use VLOOKUP when there are multiple Lookup Tables with these methods: 1. (00:15) Problem Set up 2. (01:48) IF Function 3. (05:57) IFS Function (Excel 2016 Insider Program) (Formula from XLarium at YouTube) 4. (08:47) SWITCH Function (Excel 2016 Insider Program) 5. (11:26) Names Ranges & INDIRECT Function? 6. (15:15) Summary

Comment