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.