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:
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.