Build a Named Range

[AMDRIT]

Hello,

I would like to refer to a named range by building a string, without using
VB if possible.

Named Range Address = Sheet1:A1:D10 Name = "Range1"


so that I may perform a vlookup

=vlookup(1, <"Range" + 1>, 4, false)



Any one have any ideas?

[Niek Otten]

Use the INDIRECT() function.

Look in HELP for details.

--
Kind regards,

Niek Otten

"AMDRIT" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I would like to refer to a named range by building a string, without using
> VB if possible.
>
> Named Range Address = Sheet1:A1:D10 Name = "Range1"
>
>
> so that I may perform a vlookup
>
> =vlookup(1, <"Range" + 1>, 4, false)
>
>
>
> Any one have any ideas?
>

[AMDRIT]

Thank a ton, that is exactly it.


"Niek Otten" <[email protected]> wrote in message
news:[email protected]...
> Use the INDIRECT() function.
>
> Look in HELP for details.
>
> --
> Kind regards,
>
> Niek Otten
>
> "AMDRIT" <[email protected]> wrote in message
> news:[email protected]...
>> Hello,
>>
>> I would like to refer to a named range by building a string, without
>> using VB if possible.
>>
>> Named Range Address = Sheet1:A1:D10 Name = "Range1"
>>
>>
>> so that I may perform a vlookup
>>
>> =vlookup(1, <"Range" + 1>, 4, false)
>>
>>
>>
>> Any one have any ideas?
>>
>
>