Excel Formula

[fcrabtree]

Hello. I am trying to edit my purchase/sales schedule for RM and the formula is throwing me off a bit. 

The input at the top is weeks, and based on how many weeks is entered I need row 16 to move in columns the # of weeks & to row 9.

[#2]

@fcrabtree I'm afraid you need to put a bit more effort into explaining what you need. What do you mean by "to move in columns the # of weeks & to row 9"?

Would be helpful if you could give a realistic example of what you would like to see (manually entered) as a result if the lead time is 4 weeks, for instance. And uploading the example file would be extremely helpful as well.

[#3]

Whatever # of weeks is inputted, I need row 16 to move that same number in columns. i.e. Input= 9 weeks, row 16 would move over 9 columns and to row 9. I can only share the screenshot that is in this post.

[#4]

R16, and row 9's column would be based on the inputted number of weeks.

[#5]

@fcrabtree Sorry! don't get it.