Indirect/Vlookup/???
 

I am trying to do a lookup almost entirely based on the contents of various
cells.

I want to use the values sitting in B20 and C20 to get my range. B20 reads
'Sheet2!B80' and C20 is 'Sheet2!L98'. When I use
=VLOOKUP(A20;indirect(B20):indirect(C20);D20;FALSE ) then the formula bar says
my table array is volatile.

Has anyone any idea what I should be entering?

Thanks very much.

Indirect/Vlookup/???
 

=VLOOKUP(A20;indirect(B20&":"&C20),D20;FALSE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Light" wrote in message
...
I am trying to do a lookup almost entirely based on the contents of
various
cells.

I want to use the values sitting in B20 and C20 to get my range. B20 reads
'Sheet2!B80' and C20 is 'Sheet2!L98'. When I use
=VLOOKUP(A20;indirect(B20):indirect(C20);D20;FALSE ) then the formula bar
says
my table array is volatile.

Has anyone any idea what I should be entering?

Thanks very much.

Indirect/Vlookup/???
 

Ahh, that makes more sense. Thanks.
I also eventually realised that C20 should read L98 rather than Sheet2!L98.
It always seems so simple once it's fixed.

I appreciate the help.
Light

"Bob Phillips" wrote:

=VLOOKUP(A20;indirect(B20&":"&C20),D20;FALSE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Light" wrote in message
...
I am trying to do a lookup almost entirely based on the contents of
various
cells.

I want to use the values sitting in B20 and C20 to get my range. B20 reads
'Sheet2!B80' and C20 is 'Sheet2!L98'. When I use
=VLOOKUP(A20;indirect(B20):indirect(C20);D20;FALSE ) then the formula bar
says
my table array is volatile.

Has anyone any idea what I should be entering?

Thanks very much.