How do I reference cells in multiple tabs via a formula

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

In a workeet with multiple tabs, how do you reference a
tab via formula.

Ex. with typed array=index(tab1,2,3)

Column A(array or tab) Column B
tab2 =index(a2,2,3)
tab3 =index(a3,2,3)
tab4 =index(a4,2,3)
and so on

I'm geeting a formula error for this.

Please help!
 
In a workeet with multiple tabs, how do you reference a
tab via formula.
Click to expand...

By 'work[sh]eet' do you mean workbook, that is, an Excel file? By 'tab' do you
mean worksheet, that is, a single 'page' with a row/column grid and a name that
appears in a tab at the bottom of the document window within Excel?
Ex. with typed array=index(tab1,2,3)

Column A(array or tab) Column B
tab2 =index(a2,2,3)
tab3 =index(a3,2,3)
tab4 =index(a4,2,3)
and so on
Click to expand...

What are you trying to get? If 'tab2' were in cell A2, would you expect the
formula =INDEX(A2,2,3) to return cell C2 in the tab2 worksheet? If so, try

=INDIRECT("'"&A2&"'!R"&2&"C"&3,0)
 
Back
Top