VLOOKUP and a table (1/2)

VLOOKUP and a table

If you convert your cell range to a table you can add or remove as many records to the table as you want and the cell reference in the formula is automatically adjusted. Use the table name and table column name in the vlookup function to achieve this. See the formula bar in the picture below.

How to convert acell range to a table (Excel 2007 and above)

1. Select cell range A7:E17
2. Go to tab "Insert"
3. Click table button
4. Enable "My table has headers"
5. Click OK