Archive for February 9th, 2010
Nifty Tip #4: Organizing the Data Table for Proper Use of the VLOOKUP Formula
The VLOOKUP formula searches for the lookup criteria in the leftmost column of the data table. It is recommended that the whole sheet be used as the data table, so that the VLOOKUP will automatically look at column A as the leftmost column. Defining a Name for the sheet (to use it as the Table_array, [...]