INDEX array formula using multiple criteria, * and INDIRECT references, Can it work?

Hey guys/girls,

I have been working on trying to pull payments from worksheets, that get generated each month, within my workbook. This is the formula I am using to pull the data (date-column1 and payment-column 2) but it can only use a single criteria, $F$3. I am using INDIRECT to reference different worksheets and ROW references that track down a helper column beside Column F.

Please Login or Register  to view this content.

What I would like to achieve is the above formula operating with more than one criteria.

Instead of only looking for the value in $F$3, I would like it to INDEX values from $F$1, $F$2 OR $F$3.

For example (and this does NOT work):

Please Login or Register  to view this content.

As you can see I have also tried to use IFERROR as well..

Thank you in advance for any help.

This is a stripped down version of the workbook.

FEES TRIAL DUMMY.xlsx

Whets

Not sure on the technicalities of the forum rules here but....

The formula that I got in the above help from misrasomendra was great and efficient (your awesome!), however, if there is no value in the referenced cell (F2 or F3) it returns odd (weird) values. This is because it tries to return rows that have no entries.

Is it possible to rejig this formula to allow it to skip entry less rows (as in a blank value for F2 or F3)

Here is the code directly from her/his answer:

Please Login or Register  to view this content.

Here is the spreadsheet:

353354d1413915941-index-array-formula-using-multiple-criteria-and-indirect-references-can-it-wo.xlsx

Many thanks again!

Just to add... I did spend some 3 hours on this today with results ranging from breaking excel to nearly set PC on fire... I will need to spend some time after this getting my head around this new formula... for now though I need to get this out by Friday.. lol