How can I set a variable for which column to lookup?

R

Regnab

I'm doing up a schedule to predict production levels for work. The
product proces is made up of 5 stages. The columns represent each
month. What I want to be able to do is have a variable that the user
can change so that they can vary the number of months between stages.

For example, if stage 1 only takes two months, then formulas in X will
reference values in W. If the user wanted to extend the process by a
month to see the ramifications, they could change a value and all the
formula's would then reference V column instead.

Any ideas much appreciated,

Cheers

Reg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable column reference in formula 2
Need variable that refers to same row different column 3
sum and count text and numbers same column 1
Variable Range 3
Help needed with lookup tables.. 5
How do I enter variable data into a formula 4
variable sheet name 6
Can I do Excel formula that variably shifts columns right or left 1

Top