If you are on Excel 2003, select the current table area including the
labels, activate Data|List|Create List, and keep the current VLOOKUP
formulas as is. When you add new records to the list just created, the
formulas will automatically adjust the range refernces.

artesia7 wrote:
Assume I have 400 pupils and an array that links numeric grades to a letter;
e. g., 100 = A, 90 = B, etc. How do I increase the array if I want to go
100, 95, 90, 85, 80, etc (in order to add plus or minus to the letter)?
(This is not my exact problem, but I hoped a simple example would make it
clearer.). . . Do I delete the old array and create a new one with the same
name? And where can I find instructions on how to modify, delete and add
such an array? Thanks.