# LOOKUP Help

#### mrkris1982

##### Active Member
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.

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Hi, try SUMIFS, not lookup.

OR, try a pivot table.

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)

Replies
4
Views
142
Replies
3
Views
183
Replies
5
Views
160
Replies
2
Views
396
Replies
1
Views
211

1,217,451
Messages
6,136,714
Members
450,025
Latest member
Beginner52

### 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.

### Which adblocker are you using?

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

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