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