I am trying to index/match/lookup values from a Quickbooks report that appear on another sheet in two separate columns and on different rows that will return a value from a 3rd column. I have exported a report from Quickbooks that totals based on Class and Sub-Class. I have created a separate sheet of just the class and sub-classes for easier reference, though not sure if needed. The sheet below is re-created monthly with new values. Part of the problem, is that for every Class (B), there is the same sub-class name(C). Please reference the example below. I would like to be able to have a formula on a different sheet that would pull the value for each category and sub-category. Example: I want to lookup/match Construction (B) and Total Los Angeles(C) (under the Construction category) and return the value for Total Los Angeles (N). I would like another formula to do the same for the Contents category (B). I am trying to automate my sheet with these formulas so when I have to redo each month the formulas stay the same and it's just the data that changes on the sheet below and due to the formulas, it automatically pulls the new data. I cut and past from an Quickbooks export to Excel report into the sheet below. I hope this makes sense! Any help would be greatly appreciated! 
<tbody>
</tbody>
| A | B | C | D | E | F | G | H | I | J | K | L | M | N |
| Type | Date | Num | Name | Memo | Account | Class | Debit | Credit | |||||
| Construction | |||||||||||||
| Los Angeles | |||||||||||||
| Deposit | 09/02/2016 | 2060670 | Test | Construction:Los Angeles | 12001 · Undeposited Funds | Construction:Los Angeles | 466.04 | ||||||
| Total Los Angeles | 0.00 | 466.04 | |||||||||||
| Orange | |||||||||||||
| Deposit | 09/02/2016 | 2640 | Test | Construction:Orange Deposit | 12001 · Undeposited Funds | Construction:Orange | 585.00 | ||||||
| Total Orange | 0.00 | 585.00 | |||||||||||
| Riverside | |||||||||||||
| Deposit | 09/30/2016 | VISA 4818 | Test | Construction:Riverside (partial payment for draw #3) | 12001 · Undeposited Funds | Construction:Riverside | 2,000.00 | ||||||
| Total Riverside | 0.00 | 2,000.00 | |||||||||||
| San Bernardino | |||||||||||||
| Deposit | 09/02/2016 | 2060587 | Test | BOARD UP Construction:San Bernardino | 12001 · Undeposited Funds | Construction:San Bernardino | 600.52 | ||||||
| Total San Bernardino | 0.00 | 600.52 | |||||||||||
| San Diego | |||||||||||||
| Deposit | 09/12/2016 | 0004053101 | Test | Construction:San Diego | 12001 · Undeposited Funds | Construction:San Diego | 10.00 | ||||||
| Total San Diego | 0.00 | 10.00 | |||||||||||
| Ventura | |||||||||||||
| Deposit | 09/22/2016 | 3518 | Test | Construction:Ventura | 12001 · Undeposited Funds | Construction:Ventura | 9,866.70 | ||||||
| Total Ventura | 0.00 | 9,866.70 | |||||||||||
| Total Construction | 0.00 | 13,528.26 | |||||||||||
| Contents | |||||||||||||
| Los Angeles | |||||||||||||
| Deposit | 09/01/2016 | 1614388634 | Test | PO Contents:Los Angeles | 12001 · Undeposited Funds | Contents:Los Angeles | 584.86 | ||||||
| Total Los Angeles | 0.00 | 584.86 | |||||||||||
| Orange | |||||||||||||
| Deposit | 09/01/2016 | 1614388634 | Test | PO Contents:Orange | 12001 · Undeposited Funds | Contents:Orange | 2,334.38 | ||||||
| Total Orange | 0.00 | 2,334.38 | |||||||||||
| Riverside | |||||||||||||
| Deposit | 09/01/2016 | 1614388634 | Test | PO Contents:Riverside | 12001 · Undeposited Funds | Contents:Riverside | 3,348.22 | ||||||
| Total Riverside | 0.00 | 3,348.22 |
<tbody>
</tbody>
