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