return contents of a cell referenced in another cell

[DMP3]

I would like to return the value of 1 cell which is specified in another cell.

For example:

In sheet 'details' cell C2 has the formula =
(ADDRESS(MATCH(1,pivot!B:B,0),1,4,1,"pivot"))

whose returned value is =
pivot!A11

in same sheet 'details' D2 cell I would like it to return the contents of cell A11 in sheet 'pivot' whose contents/value is =
10/16/2010

thank you!

 

[VoG]

Try

=INDIRECT("C2")

 

[DMP3]

PERFECT, thank you!