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
spreadsheet. The line item names are identical for the first 3
in each tab, so 'vlookup' is not an option. Further, the same tab
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
Can anyone help me with a function? I need specific row/column
and INDEX didn't seem to provide results.
I see from threads that =INDIRECT(ADDRESS... is not the preferred
Help? and thanks!