C CLGonline Jun 2, 2009 #1 need assistance to build formula so i can use cell contents to create links to other tabs within spreadsheet
need assistance to build formula so i can use cell contents to create links to other tabs within spreadsheet
C CLGonline Jun 3, 2009 #2 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)
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 Jun 3, 2009 #3 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 =
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 =
