Build a Named Range

A

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?
 
Top