VLOOKUP variable range cell reference

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP -- Table Array Problem 1
Using Value of a Cell in the Range Reference in VLOOKUP 1
Using VLOOKUP results in a DSUM criteria range 2
using a defined Name in a function 2
Vlookup - using a cell to reference a named array 3
How do I insert a dynamic reference of a range inside VLOOKUP? 4
Vlookup and return sheet name also 2
using strings in vlookup function calls 5

Top