Dynamic Array, Index & Match, SUMIFS Formula Help!

[garrett.grillo]

Hi Excel Forum Team,

I have a cash flow spreadsheet (see attachment or link to example below) that I need a formula for (A2:D6) that will automatically search through the larger cash flow spreadsheet below (A9:O13) and will return a single cost value that resided in a specified cell (D10:O13).

The formula will be able to find the correct horizontal column title (A9:O9), then once the formula finds the correct column title, it will search the vertical rows for three unique values WBS Code, Vendor Code, and Purchase Order Number (A10:C13). This will now allow the formula to target in on both horizontally and vertically to one cell that contains the specified project cost value (D10:O13) and return its findings back up to the specified month column above (D3:D6).

Please help me on this one I’m truly stuck and can’t get the formula to work right and I’m not sure if I need a Dynamic Array, Dynamic Index & Match, Dynamic SUMIFS or some other formula all together.

Thank You!

Dynamic Array Index Match Example.xlsx

Garrett