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 c...
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...
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...



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.