View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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)