Adding to cell reference?

[bre]

I have a pasted link that refers to another worksheet. It shows up as

=MAIN!$AH$21

My question: Is there any way to add to this like so

=MAIN!$AH$21+10 so that it will now reference AH31?

In the MAIN sheet, ah21 has a 5. If I use =MAIN!$AH$21+10. it is showing 15 instead of the value that is in ah31.

Thanks.

[Domenic]

Try the following...

=INDIRECT("MAIN!$AH$"&21+10)

or

=INDIRECT("MAIN!$AH$"&A1)

...where A1 contains the row number of interest.

Hope this helps!