|
Featured Tutorial
Featured Macro
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.