Index/Match result should again search for zero result

Please help for a formula:

If Index/Match result is zero, the formula should again search with same combination in the same array

Do you have only one Number for desired Date and Name?

If yes you can use SUMIFS:

Formula:

Please Login or Register  to view this content.

Do you have only one Number for desired Date and Name?

If yes you can use SUMIFS:

Formula:

Please Login or Register  to view this content.

Try this.....
In H2

Please Login or Register  to view this content.

and then copy down.

Enable Automatic Calculation on the sheet. Go to Formula tab --> Calculation Options --> Select Automatic.

Is this what you are trying to achieve?