Learn Excel - Lookup Row & Sheet - Podcast 2173 HD

Rhonda from Cincinnati: How to look up both row and worksheet? Use the Date column to figure out which sheet to use Step 1: Build a regular VLOOKUP and use FORMULATEXT to see what the reference should look like Step 2: Use Concatenation and the TEXT function to build a reference that looks like the table array reference in the formula Step 3: Build your VLOOKUP, but for the table array, use INDIRECT( results from step 2) Step 4: Copy the formula from Step 2 (without the equals sign) and paste in to the formula from step 3