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

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

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

Sounds like you need to use the INDIRECT function somewhere in your
custom function.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=560497