Excel Forum

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.