View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Regnab Regnab is offline
external usenet poster
 
Posts: 7
Default 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