using cell contents to link to other tabs

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
 
G

Gord Dibben

As I replied in other group you multi-posted to.............more details,
but INDIRECT function is what you need.


Gord Dibben MS Excel MVP
 
S

Shane Devenshire

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

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

Similar Threads

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Using Styles In An Outline 0
Excel - Wich Function should I use? 1
How do I install Microsoft Equation 3.0 back to Office 365? 0
code to unhide tabs based on cell contents 7
formula to link to other tabs 2
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1

Top