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
Bookmarks