how to use a current sheets value to be used a reference to a different sheet cell

[jerbutler]

Hi,

Im looking to to use a current sheets value to be used a reference to a different sheet cell

eg:
=Sheet1!("A"&=Sheet2!A2)
where =Sheet2!A2 is the row number

Regards

 

[BarryL]

is this in vba or just excel? I think you want INDIRECT maybe something like

=INDIRECT("Sheet1!A"&Sheet2!A2)