Defining ranges

S

Sivodsi

In a reply to my thread "the terror of advancing cell numbers" a ver
helpful reply was given:

\"OR YOU COULD DEFINE A RANGE NAME THAT POINTS AT A1:Z100.

SELECT YOUR RANGE AND TYPE:
MYRNG
(OR WHATEVER YOU WANT TO CALL IT)
AND HIT ENTER

THEN YOUR =VLOOKUP() BECOMES:

=VLOOKUP(A1,MYRNG,2,FALSE

I have tried this but could not quite do it. Selecting the range is n
problem, of course, but where do I type "myrng" (or whatever I wish t
call it)? Can someone help this poor newb with more precise direction
for defining ranges?

Thanks Davi
 
N

Norman Jones

Hi Sivodsi,

Type the name in the name box which immediately above cell A1 and below the
toolbars.

Don't forget to press Enter after typing the name!
 
D

Dave Peterson

And sorry about my missing:

And type
MYRNG into the namebox--just to the left of the formula bar
and hit enter.

(glad you got it working)
 
Top