Hi

Use dynamic range.

P.e. you have the grade table (GradeNum,GradeText) on sheet Grades - with
headers in cells A1:B1. Define a named range (InsertNameDefine) Grades
with source
=OFFSET(Grades!$A$1,1,,COUNTA(Grades!$A:$A)-1,2)
So long as you don't have any gaps in column A on sheet Grades, and don't
delete the header row, the named range adjusts automatically whenever you
add a row or delete one

Now you can write your VLOOKUP formula like this
=VLOOKUP(LookupValue,Grades,2,0)


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"artesia7" wrote in message
...
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.