Thread: how do i convert this to a formula +"sheet1!J"&(sheet2!A30)-1
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
  
Posts: 364
Default how do i convert this to a formula +"sheet1!J"&(sheet2!A30)-1
"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)


Reply With QuoteReply With Quote