Add cell value in sheet2 to Sheet1!A1

[Tour]

Hi all, seemingly simple problem but I can't figure this one out for the life of me.

I have the following situation:
Sheet2 has a value (number) that I need to add to the formula =Sheet1!A1 in the way that it replaces the 1 in A1.
I guess that I need the formula to actually be =Sheet1!Ax where x is the value in the cell on sheet2.
Hopefully I have explained that well enough.

I have already tried some stuff such as:
=Sheet1!AB2 where B2 is the cell on Sheet2 which I'm trying to get the value of.

=Sheet1!A=Sheet2!B2

I really don't know what to do. Any help is appreciated, thanks in advance!

 

[repairman615]

Hello,

Try the INDIRECT() function. Read through the help file on this to save many headaches.

=INDIRECT("A"&Sheet1!$B$2)