How do i lengthen an existing VLOOKUP table array?
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.
|