Indirect(address...function help?
 

Hi there,

This seems to be the group of which to ask questions since I'm a
newbie to Excel intricate function!


I'm trying to merge pivot table results from 3 different tabs onto
one
spreadsheet. The line item names are identical for the first 3
columns
in each tab, so 'vlookup' is not an option. Further, the same tab
will
contain the same line item name due to different account numbers thus
nullifying the 'getpivot' function.


I tried the formula =INDIRECT(ADDRESS(row,column,3,1,"tab_name")).
That works swell until a new line gets inserted into one of the
tabs. AAARRGGHHH.


Can anyone help me with a function? I need specific row/column
results,
and INDEX didn't seem to provide results.


I see from threads that =INDIRECT(ADDRESS... is not the preferred
function.


Help? and thanks!

Indirect(address...function help?
 

Check out the GETPIVOTDATA function.
http://office.microsoft.com/en-us/ex...091071033.aspx

http://www.contextures.com/xlPivot06.html

Regards,
Ryan---



--
RyGuy


"brewdon" wrote:

Hi there,

This seems to be the group of which to ask questions since I'm a
newbie to Excel intricate function!


I'm trying to merge pivot table results from 3 different tabs onto
one
spreadsheet. The line item names are identical for the first 3
columns
in each tab, so 'vlookup' is not an option. Further, the same tab
will
contain the same line item name due to different account numbers thus
nullifying the 'getpivot' function.


I tried the formula =INDIRECT(ADDRESS(row,column,3,1,"tab_name")).
That works swell until a new line gets inserted into one of the
tabs. AAARRGGHHH.


Can anyone help me with a function? I need specific row/column
results,
and INDEX didn't seem to provide results.


I see from threads that =INDIRECT(ADDRESS... is not the preferred
function.


Help? and thanks!