Hello, little help please


In the vlookup formula I know you can use a name range as below:


=VLOOKUP(A3,named_rage,1,FALSE)

but is it possible to refer to the “named_range” through a cell

E.g.

=VLOOKUP(A3,A3,1,FALSE)


Can you use the contents of cell A3 to refer to the named_range????

And if so how???


Note there are many “named_ranges” on multiple sheets



Thanking you in advance