Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Column Lookup
I have three columns to the left column K each has a header with the year
number. 2008, 2009 and 2010. Underneath each of the three columns I have numerical data. On the same header row I have a drop down list in K1. So when I pick 2009, I want the calculations in K2, K3 downward to use the corresponding data in column that has the matching year. 2008 2009 2010 2009 (drop down) 2 3 6 3*10 If I choose the drop down of 2008 then the formula should be 2*10 If I choose the drop down of 2010 then the formula should be 6*10 The actual formula is much more complicated involving INDEX/MATCH, but I think this should relay the idea. Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 variable Lookup | Excel Discussion (Misc queries) | |||
Lookup using variable name | Excel Worksheet Functions | |||
Variable Lookup/Double Lookup | Excel Worksheet Functions | |||
How can I set a variable for which column to lookup? | Excel Discussion (Misc queries) | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions |