Excel Forum
Similar Content
Countdown Timer in Excel
Tutorial: How to create a countdown timer in Excel. This allows you to display a timer in whatever ...
Group Data Together for Increased Readability in Excel
Tutorial: How to group data together or collapse it in order to focus only on the important data in...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Mr Excel & excelisfun Trick 40: VLOOKUP to 3 Different Lookup Tables (3 table_arrays)


See Mr Excel and excelisfun show how to do a VLOOKUP to 3 different tables using these tricks:
1)INDIRECT and CHOOSE
2)CHOOSE alone
3)INDIRECT with a defined name (named range)
4)CHOOSE with a defined name (named range)
Learn how to copy a sheet and paste a defined name with keyboard shortcuts.





Got a Question? Ask it Here in the Forum.