I have a worksheet where I dump exported data from another program. The
worksheet has a main category in column A and subcategories in column B.
(Example below).

I am interested in finding data in the row "Total Contribution" under the
category of "Construction Loan".

Is there a way to ask for a nested MATCH statement on both "Construction
Loan" and "Total Contribution" ? As you can see, the title "Total
Contribution" is repeated in each of the Column A categories, and I just want
the data for the Construction Loan category. Further, the title in Column A
is only at the top of each section, and not repeated in front of the
Subcategories of Column B.

I can see some possible work-arounds, but what would be the best way to
retrieve the data I want? Thanks.


Data example:


Finance : Equity
Timed Contribution: Project
Auto. Project Contribution
Total Contribution
Finance : Construction Loan
Timed Contribution: Project
Auto. Project Contribution
Total Contribution
Finance : Mortgage
Opening Balance
Total Loan Fees
Total Contribution