Hi:

I'm having some more trouble with index match match formula for a worksheet I've setup. I have a list of CSA's that I need to find specific data for (Total Avg Active Service). The index match match formula I am using is returning #N/A.

The results I'm trying to get are:

for every CSA listed on worksheet "KPI Report Avg Active Service", return their average for the specified parameter (Total Avg Active Service),week, and month (which I have calculated on worksheet "Call Data" {range: BH:BM})

I've attached an example showing my failed attempts.

Any help with this would be appreciated!

index match match example.xlsx