Index Match issues

I am having issues with an index match formula only returning 0 values when it should be returning varying numbers to me. I am populating the Dashboard Information sheet with information from the Calculations sheet, and at one point, the formula only returned the correct numbers for the first person on the roster, but not the second. Now the formula is only returning 0 values. I've retyped/reformatted the information multiple ways trying to get it to work, but to no avail. Can anyone provide any insight?

Apologies, fired that off way too early without appropriate detail. On the Dashboard Information sheet, there is a series of boxes of data that are being pulled from the Calculations sheet. Below the second box of data titled Team Load Breakdown + EWMA ACWR, there is a data that I am trying to pull for each individual, using Index Match. The Index is the column of Table 4 titled EWMA A:C (from the calculations page) and it is matching to the name at the top of that third cluster of data on the Dashboard Informatiom sheet in addition to matching the date in column A, and it is all of those data points (ACWR, strain and TSB) that are showing 0 values where they shouldn’t when matched with the two conditions I specified. Does this pinpoint things better?

Originally Posted by avk

In "Dashboard Information" Sheet in cell "B48" which answer required. Enter manually some required results.

Here is what should this person's actual results should be for each cell