Indirect(address...function help?

B

brewdon

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top