Excel Index and Match function with multiple criteria not searching the next record

Safety Stats Image.jpg
I have a spreadsheet wherein I need to find data based on multiple search criteria. I have used the Index with Match function to find the first record in the spreadsheet however I am unable to get to the next record in the data set.

The file name is "Safety Stats" and the data is in the [Occupational Injuries] tab. I need to find all records where the month is pervious month, the "Employee/Contractor" column is "Employee" and the "Injury Type" column is not "First Aid" or "Reported Only". I want excel to pull data based on my criteria from this spreadsheet into a different excel report every month.

My function is locating the first occurrence however I am unable to find the next record in the data set. Any help will be highly appreciated.

Here is the function I have written.
[CODE][CODE][CODE]{=IF(
ISNA(
INDEX(
'[Safety Stats.xlsx]Occupational Injuries'!$C$5:$C$128,
MATCH(1,
('[Safety Stats.xlsx]Occupational Injuries'!$A$5:$A$128=TEXT(EOMONTH(TODAY(),-1),"MMMM")) *
('[Safety Stats.xlsx]Occupational Injuries'!$F$5:$F$128="Employee") *
('[Safety Stats.xlsx]Occupational Injuries'!$I$5:$I$128<>"First Aid") *
('[Safety Stats.xlsx]Occupational Injuries'!$I$5:$I$128<>"Reported Only"),0))),"",
INDEX('[Safety Stats.xlsx]Occupational Injuries'!$C$5:$C$128,
MATCH(1,
('[Safety Stats.xlsx]Occupational Injuries'!$A$5:$A$128=$Y$9) *
('[Safety Stats.xlsx]Occupational Injuries'!$F$5:$F$128="Employee") *
('[Safety Stats.xlsx]Occupational Injuries'!$I$5:$I$128<>"First Aid") *
('[Safety Stats.xlsx]Occupational Injuries'!$I$5:$I$128<>"Reported Only"),0)))}

Below is the DATA:

Month Day Full Name Years of Experience Occupation Employee /Contractor Location Department Injury Type
May 05 Bery Owen 5 Welder Employees 2. Maintenance Maint Shop Medical Treatment Injury
May 09 Samyy Wood 3 Services Contractor 2. Maintenance Services First Aid
May 11 Sunny Man 4 Operator Employees 1. Production Operation Medical Treatment Injury
May 15 Rick Richard 1 Operator Employees 4. Others Plant Lost Time Injury
May 19 Patty Westwood 6 Maint Employees 4. Others Machinery First Aid
May 21 Tim Bear 3 Maint Contractor 4. Others Services Reported Only
May 24 Angela Petterson 5 Mechanic Employees 1. Production Operation First Aid
May 25 Martin Butin 4 Tradesman Employees 1. Production Operation Restricted Work Injury
May 29 Roy Mathew 6 Rigger Employees 1. Production Operationy First Aid

INDEX/MATCH will only ever find the 1st match, and then stop looking.

I will take a look at your file and see if I can come up with something for you

hmm it says there is a problem loading your file, can you upload again please?

Originally Posted by FDibbins

hmm it says there is a problem loading your file, can you upload again please?

I got the same.

Ford this is the second thread (upload) I've gotten this error today. Possible forum issue?

Originally Posted by FlameRetired

I got the same.

Ford this is the second thread (upload) I've gotten this error today. Possible forum issue?

Dont think so Dave, I have opened a few files already today

Me too. I just thought it weird that I got the same message twice in one day.

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Cross posted on at least two other forums

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).