how do i convert this to a formula +"sheet1!J"&(sheet2!A30)-1

  • Thread starter Thread starter joel
  • Start date Start date
joel said:
can someone help me ?
Click to expand...

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)
 
Joel, Next time, put your question within the body of the message, not the
subject. Next, you don't reference a cell in your "formula" in the first
part, ie "J". Tell us what is in the cells you are reference so we can help
you because the "&" is probably not necessary. Not sure why you have quotes.

Les
 
Back
Top