Main Profile

At A Glance

Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how to do a 2-way lookup from multiple tables when the tables are on the same sheet or different sheets using 5 different methods:1. VLOOKUP and CHOOSE function method -- tables on same sheet2. VLOOKUP and CHOOSE function method -- tables on different sheets3. INDEX, MATCH and CHOOSE function method when lookup criteria is different in each table.4. VLOOKUP and INDIRECT function using Defined Names - tables on different sheets5. VLOOKUP and INDIRECT function using Test String to define table ranges - tables on different sheets
Length: 24:28

Contact

Questions about Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets

Want more info about Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question