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:A110 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.

 

[AMDRIT]

Thank a ton, that is exactly it.

Use the INDIRECT() function.

Look in HELP for details.