Range naming
 

I have a range that I have named "RANGE1". I can do a vlookup on this range
by putting the range name in the formula instead of the actual range. Is it
possible to place the word RANGE1 in a cell (say A1) and then reference the
cell A1 in the formula? I want to be able to change what the vlookup looks
for by changing the range name in A1.

Thanks!

Squeaky

Range naming
 

Hi,

Yes, use:

INDIRECT(A1) istead of the range name.

HTH
Jean-Guy

"Squeaky" wrote:

I have a range that I have named "RANGE1". I can do a vlookup on this range
by putting the range name in the formula instead of the actual range. Is it
possible to place the word RANGE1 in a cell (say A1) and then reference the
cell A1 in the formula? I want to be able to change what the vlookup looks
for by changing the range name in A1.

Thanks!

Squeaky

Range naming
 

Worked like a charm.

Thanks pinmaster.

"pinmaster" wrote:

Hi,

Yes, use:

INDIRECT(A1) istead of the range name.

HTH
Jean-Guy

"Squeaky" wrote:

I have a range that I have named "RANGE1". I can do a vlookup on this range
by putting the range name in the formula instead of the actual range. Is it
possible to place the word RANGE1 in a cell (say A1) and then reference the
cell A1 in the formula? I want to be able to change what the vlookup looks
for by changing the range name in A1.

Thanks!

Squeaky