LOOKUP Help

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.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

63falcondude

Well-known Member
Joined
Jan 15, 2016
Messages
3,572
How's this:


Excel 2010
BCDEFGHIJK
1MonthsAppsTotal HoursMonthAppHours
2Jan-16a1Apr-16b10
3Jan-16b2
4Jan-16c3
5Feb-16a4
6Feb-16b5
7Feb-16c6
8Feb-16d7
9Mar-16a8
10Apr-16a9
11Apr-16b10
12Apr-16c11
13Apr-16d12
Sheet1
Cell Formulas
RangeFormula
K2=SUMIFS(F:F,B:B,I2,C:C,J2)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,523
Messages
5,854,219
Members
431,627
Latest member
mantesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top