Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Can the column index in a cell address be made variable? | Excel Discussion (Misc queries) | |||
Lookup values in one column to return another | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions |