Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?

Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm

See how to do a VLOOKUP to a different Sheet using:
1. Sheet References
2. Defined Names
3. Table Formula Nomenclature (Structured References)

Leave a Reply

Close Menu