Rules for 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 Vlookup will automatically look at column A as the leftmost column.
Defining a Name for the sheet (to use it as the Table_array (the second argument in the Vlookup formula) will eliminate the need of updating the range reference in any Vlookup formula.
To define a Name for the sheet:
1. Select a cell, and click Select All (the button at the top-left corner of the intersection between rows and columns).
Press Ctrl+A. (In Excel 2003, press Ctrl+A+A when selecting a cell in a region.)
2. Press Ctrl+F3, and in the Names in workbook box, type the Name for the data table.
3. Click OK.
Screenshot // Vlookup Formula – Organizing the Data Table
Vlookup Formula – Organizing the Data Table
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.