Re: $$Excel-Macros$$ dynamic range (table_array) in vlookup formule

2010-10-08 Thread Ramkesh Maurya
Dear Carlo, Select Range Q:R i.e. both entire col and vlookup is enough Regards Ramkesh On Thu, Oct 7, 2010 at 5:48 PM, cg wrote: > Hi everybody > I’ve a big trouble but maybe, for you is an easy trouble. > > I’m working on excel2003. > I’ve to compare two values, in the same pivot table, usin

$$Excel-Macros$$ dynamic range (table_array) in vlookup formule

2010-10-07 Thread cg
Hi everybody I’ve a big trouble but maybe, for you 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$