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

On Tue, 2 Jun 2009 16:06:01 -0700, CLGonline
wrote:

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

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")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"CLGonline" wrote:

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