INDIRECT Sheet name and cell reference.

[mdo8105]

I have a sheet that has a Sheet name in cell W10 and the cell I want to reference on the sheet in cell Z10. What is the best way to use Indirect to accomplish my goal. I know if I use = INDIRECT(W10&"!D19), it will return the value in cell D19 on the Sheet referenced on cell W10, but I also want to replace D19 with what is referenced in Z10.

Thank you.

 

[dreid1011]

Something like this perhaps:

=INDIRECT("'"&W10&"'!"&Z10)

 

[mdo8105]

Yes, that is perfect! Thank you so much!!!!

 

[dreid1011]

You're welcome