Wanting to use text from a cell as a value in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking to use the value in a cell in a formula which points at a
worksheet with the same number.

I have 115 worksheets and 1 summary page at the front, in column A I have
the worksheet number which the results in that row relate to ie 1, 2, 3,
reflect figures in worksheet (1), worksheet (2), worksheet (3) etc...

To save time I am looking for a way that I can use the number in column A in
the formula that looks up the value in the worksheet require ie
='worksheet(x)'!$B$6 but replace x with the value in column A and then fill
down for all worksheets.

Can anyone help?
 
You need the INDIRECT function, something like

=INDIRECT("'worksheet("&A2&")'!$B$6")

where A2 contains the worksheet number
 
Back
Top