VLOOKUP variable range cell reference
 

Hello

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

VLOOKUP(a1;sheet!A10:D500;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.
--
OHP

VLOOKUP variable range cell reference
 

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

remove nospam for email addy!



"Ohp" wrote:


Hello

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

VLOOKUP(a1;sheet!A10:D500;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.
--
OHP

VLOOKUP variable range cell reference
 

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.

--
OHP


"paul" wrote:

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

remove nospam for email addy!



"Ohp" wrote:


Hello

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

VLOOKUP(a1;sheet!A10:D500;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.
--
OHP