how do i convert this to a formula +"sheet1!J"&(sheet2!A30)-1
Thank you very much it is very helpfull to use such a formula.
"Stephen" wrote:
"joel" wrote in message
...
can someone help me ?
Please ask your question in the body of the post, not the subject line!
Is this what you want?
=INDIRECT("Sheet1!J"&Sheet2!A30-1)
|