dynamic range (table_array) in vlookup formule

[cuoredicapitano]

Hi everybody
I’ve a big trouble but maybe, for your, is an easy trouble.

I’m working on excel2003.
I’ve to compare two values, in the same pivot table, using vlookup.
My problem is that, the table_array, must be dynamic.
Sometimes the range is: SheetTest!$Q$1:$R$10; other times, could be
!$Q$70:$R$100 or other..
How can I create dinamically the range “SheetTest!$Q$1:$R$10” in the
VLOOKUP formule?
I tried to use =INDIRECT(“SheetTest!$Q$1);
The problem is how to write the “:” ecc…
VLOOKUP(“test”; INDIRECT(“SheetTest!” & $Q$1): INDIRECT(“SheetTest!” &
$Q$1)…..
But it’s wrong.
How can I do?
Many thanks
Carlo

The pivot table has structured so:

param1
value1.a value1.b value1.c
value2.a value2.b value2.c
param2
value1.a value1.b value1.c
value2.a value2.b value2.c


I’m using the vlookup to take value for the param2

Many Thanks!
cg

[DonkeyOte]

If it is the DataBodyRange that is altering why not use GETPIVOTDATA rather than VLOOKUP ?

[cuoredicapitano]

If it is the DataBodyRange that is altering why not use GETPIVOTDATA rather than VLOOKUP ?

Thanks, you've just solved my problem!
Many thanks!
cg