formula to link to other tabs

C

CLGonline

need assistance to build formula so i can use cell contents to create links
to other tabs within spreadsheet
 
C

CLGonline

i am trying to use the contents of a couple of cells to build the name of the
tab to pull the cell contents from

ColumnA ColumnB
row1 6 1

need to combine the above cell contents to get the contents from cell C2 of
the tab 6-1 (i.e. results into =+'6-1'!C2)
 
S

Shane Devenshire

Try this

=INDIRECT("'"&A1&"-"&B1&"'!C2")

where 6 is in A1 and 1 is in B1.

Drop the =+ signs from your formulas, all they do is waste space, memory and
typing time, just enter =
 

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

Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Consolidation Table from Different Excel Tabs with Different Format 1
Excel - Wich Function should I use? 1
How do I link a cell in a workbook? 1
Cells not updated automatically 3
Link To File That No Longer Exists 1
How to paste the same cell one tab over 1
How Do I Avoid #REF! In Formulas? 5

Top