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