Excel Forum



Excel Magic Trick #231: VLOOKUP w 3 Tables on Diff Sheets


See how use VLOOKUP when there are 3 tables on 3 different sheets. See how to use the VLOOKUP & INDIRECT functions as well as named cell ranges in a formula that can handle lookup in three 3 different tables. Also see an Excel Consolidation to accomplish the same task.





Got a Question? Ask it Here in the Forum.