Index Match Match for weekly range

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

Hi,
Please find attached excel..i hope your problem is resolved.

Suahs

Thank you, Suahs!

This worked great. I had to change the output to seconds, because the formula was returning decimal points. But other than that, this is fine.

Thanks, again (you get a star! )