mrkris1982
Active Member
- Joined
- Apr 16, 2009
- Messages
- 407
Column B: List of months
Column C: List of applications
Column F: Total Hours
In column I, I have data validation list pointing to the months in column B
In column J, I have a data validation list pointing to the apps in column C
In column K, I want the total time in column F to appear here based on what is selected in column I and J
Scenario: I select January in Column I......Select App2 in column J....Column K should automatically return a value of 496 hours (since that is defined in column F) and I feel this is done through a lookup but not sure. Any advice on how to write the lookup? In English it would basically say "Show me the total hours from a chart when any combination of a month and application is chosen"
Once this is resolved, will I be able to perform calculations off the number returned in column K? So in column L, I'd enter a number....in column M would subtract column L from K and show a total.
Thanks in advance.
Column C: List of applications
Column F: Total Hours
In column I, I have data validation list pointing to the months in column B
In column J, I have a data validation list pointing to the apps in column C
In column K, I want the total time in column F to appear here based on what is selected in column I and J
Scenario: I select January in Column I......Select App2 in column J....Column K should automatically return a value of 496 hours (since that is defined in column F) and I feel this is done through a lookup but not sure. Any advice on how to write the lookup? In English it would basically say "Show me the total hours from a chart when any combination of a month and application is chosen"
Once this is resolved, will I be able to perform calculations off the number returned in column K? So in column L, I'd enter a number....in column M would subtract column L from K and show a total.
Thanks in advance.