using cell contents to link to other tabs

  • Thread starter Thread starter CLGonline
  • Start date Start date
C

CLGonline

need equation / function that combines the contents of two or more cells to
determine the name of the tab of which to extract the contents from
 
As I replied in other group you multi-posted to.............more details,
but INDIRECT function is what you need.


Gord Dibben MS Excel MVP
 
Hi,

to combine the two or more cells use the & sign or CONCATENATE function.
Combine this with the INDIRECT function. For example if you want to retrieve
the data in cell A5 of the January Sales sheet and January in in A1 of a
different sheet and Sales is in B1 of that sheet your formula would be:

=INDIRECT("'"&A1&" "&B1&"'!A5")
 
Back
Top