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.