Looking up values on another worksheet

  • Thread starter Thread starter Steve F
  • Start date Start date
S

Steve F

if i have a summary workheet where there are two columns

Column A Column B
sheet2 =Sheet2!$I$26
sheet3 =Sheet3!$I$26
sheet4 =Sheet4!$I$26

is there away to amend the "worksheet" name in column B so that it
uses the value in column A

ie. what function in column B for 1st set of data can return the value
of cell I26 from the worksheet refrred to in Column A?

Hope this makes sense

Thanks in advance

Regards
Steve
 
=indirect("'" & a1 & "'!i26")



if i have a summary workheet where there are two columns

Column A Column B
sheet2 =Sheet2!$I$26
sheet3 =Sheet3!$I$26
sheet4 =Sheet4!$I$26

is there away to amend the "worksheet" name in column B so that it
uses the value in column A

ie. what function in column B for 1st set of data can return the value
of cell I26 from the worksheet refrred to in Column A?

Hope this makes sense

Thanks in advance

Regards
Steve
Click to expand...
 
Back
Top