VLOOKUP variable range cell reference

[Ohp]

Hello

I need to use VLOOKUP function with a variable table array cell reference.
Example

VLOOKUP(a1;sheet!A10500;4)

The cell reference A10 will change in every case. I know how to calculate a
text string with the correct cell reference, but i am not able to "transfer"
this to the table array argument on the vlookup function.

Many thanks.

 

[paul]

=indirect() will let you use your text reference in your formula

 

[Ohp]

Thank you by your answer, but I am still not able to solve the question. How
I must use indirect. I tried without sucess the following way :

VLOOKUP(a1; indirect(teste); 4 ).

teste as a text cell with the content : sheet!a10:d500

Thank you in advance by your support.