Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2405998%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2405998%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I%20am%20trying%20to%20edit%20my%20purchase%2Fsales%20schedule%20for%20RM%20and%20the%20formula%20is%20throwing%20me%20off%20a%20bit.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20input%20at%20the%20top%20is%20weeks%2C%20and%20based%20on%20how%20many%20weeks%20is%20entered%20I%20need%20row%2016%20to%20move%20in%20columns%20the%20%23%20of%20weeks%20%26amp%3B%20to%20row%209.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(2).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F285448i9D9437E6ACAAFADA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(2).png%22%20alt%3D%22Screenshot%20(2).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2405998%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2406769%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2406769%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1068726%22%20target%3D%22_blank%22%3E%40fcrabtree%3C%2FA%3E%26nbsp%3BI'm%20afraid%20you%20need%20to%20put%20a%20bit%20more%20effort%20into%20explaining%20what%20you%20need.%20What%20do%20you%20mean%20by%20%3CEM%3E%22to%20move%20in%20columns%20the%20%23%20of%20weeks%20%26amp%3B%20to%20row%209%22%3C%2FEM%3E%3F%3C%2FP%3E%3CP%3EWould%20be%20helpful%20if%20you%20could%20give%20a%20realistic%20example%20of%20what%20you%20would%20like%20to%20see%20(manually%20entered)%20as%20a%20result%20if%20the%20lead%20time%20is%204%20weeks%2C%20for%20instance.%20And%20uploading%20the%20example%20file%20would%20be%20extremely%20helpful%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2408415%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2408415%22%20slang%3D%22en-US%22%3EWhatever%20%23%20of%20weeks%20is%20inputted%2C%20I%20need%20row%2016%20to%20move%20that%20same%20number%20in%20columns.%20i.e.%20Input%3D%209%20weeks%2C%20row%2016%20would%20move%20over%209%20columns%20and%20to%20row%209.%20I%20can%20only%20share%20the%20screenshot%20that%20is%20in%20this%20post.%3C%2FLINGO-BODY%3E
New Contributor

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.

Screenshot (2).png

4 Replies

@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.

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.
R16, and row 9's column would be based on the inputted number of weeks.

@fcrabtree Sorry! don't get it.