Getting Value from Sheet which referencing location on another....

[ermccarthy]

I am attempting to get the value of a cell that is located on a different sheet/Tab. But, the actual Cell location is on a different tab.... Seems odd, but bear with me.

I want the value from the Sheet Titled "Daily Report". The actual Cell I want on that sheet is located on the tab: "Set Up" in cell D76. (this is set up by the initial user). The value in that cell is "C35".

Therefore I need a formula that looks something like: ="Daily Report'!&"Set Up"!D76 The end result is to return the Value of Cell Daily Report C35 to that cell, while giving the end user the ability to adjust it for their specific report format..... I have played around with it, and can not seem to figure it out..

Thoughts? Thank you in Advance!!

 

[Misca]

Sounds like INDIRECT is the function you're looking for: It changes text to a cell reference: =INDIRECT("'Daily Report'!"&Setup!D76)

 

[ermccarthy]

Worked Perfectly!! THANK YOU!!!!