Use INDIRECT to Reference Sheets Within VLOOKUP

Опубликовано: 04 Март 2013
на канале: Computergaga

125,696

459

Use the INDIRECT function to reference sheets within the VLOOKUP function. You can perform a VLOOKUP across the sheets of a workbook by nesting the INDIRECT function. This will include the sheet name within the table array reference of the formula.

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 ►   / 18737946
Instagram ►   / computergaga1
Twitter ►   / computergaga1