cell reference separated from formulae

[Johanbb]

I have a question regarding cell referencing (range).
For instance in the vlookup function you defilé the range in the second part as i.e. C3:E9
like this vlookup(what, range, position, false). I know that you can select the range and rename this.

But can I also put the range as input in for instance in cell A1 like this C3:E9

And in the formulae reference to cell A1 for the range, it is not working but do not know how to put this there maybe in brackets or something like that.

Appreciate your help.

 

[steve the fish]

Hi. Yes you could use INDIRECT. For example:

=VLOOKUP(B1,INDIRECT(A1),3,0)