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



Online Courses for microsoft excel :

Course updated 2011-11-13 22:51:54

Instructor : ExcelIsFun

Course Duration : 24:28

Rating : 5.00 / 5

Step by step & Descreption :
Download file:
See 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 sheet
2. VLOOKUP and CHOOSE function method — tables on different sheets
3. 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 sheets
5. VLOOKUP and INDIRECT function using Test String to define table ranges – tables on different sheets