VLOOKUP Formula with Conditional Lookup Table

Set up a conditional lookup table for your VLOOKUP formula. If you have multiple lookup tables for your VLOOKUP formula, it may be worth setting up a conditional lookup table where the user specifies the lookup table to use. This video shows how the INDIRECT function used with VLOOKUP to reference named ranges and have the lookup table dependent upon a user selection from a list. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1