Dueling Excel 040


VLOOKUP to 3 Different Lookup Tables (3 table_arrays)

DESCRIPTION

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.

WORKBOOKS




Be the first to comment

Leave a Reply