MushtaqKadar
New Member
Below is my formula which is giving me a #NUM!. How can I fix it. I have to spreadsheet. One with the data called "Safety Stats" and the other one is actual report where I am using this formula to pull the record from the data file i.e "Safety Stats"
=IF(INDEX('[Safety Stats.xlsx]Occupational Injuries'!$J$5:$J$128,SMALL(IF('[Safety Stats.xlsx]Occupational Injuries'!$A$5:$A$128=TEXT(EOMONTH(TODAY(),-1),"MMMM"),IF('[Safety Stats.xlsx]Occupational Injuries'!$F$5:$F$128="Employee",IF(1-ISNUMBER(MATCH('[Safety Stats.xlsx]Occupational Injuries'!$I$5:$I$128,{"FA - First Aid","RO - Reported Only"},0)),ROW('[Safety Stats.xlsx]Occupational Injuries'!$J$5:$J$128)-ROW('[Safety Stats.xlsx]Occupational Injuries'!$J$5)+1))),ROWS($A$2:A2)))="Struck Against","X","")
=IF(INDEX('[Safety Stats.xlsx]Occupational Injuries'!$J$5:$J$128,SMALL(IF('[Safety Stats.xlsx]Occupational Injuries'!$A$5:$A$128=TEXT(EOMONTH(TODAY(),-1),"MMMM"),IF('[Safety Stats.xlsx]Occupational Injuries'!$F$5:$F$128="Employee",IF(1-ISNUMBER(MATCH('[Safety Stats.xlsx]Occupational Injuries'!$I$5:$I$128,{"FA - First Aid","RO - Reported Only"},0)),ROW('[Safety Stats.xlsx]Occupational Injuries'!$J$5:$J$128)-ROW('[Safety Stats.xlsx]Occupational Injuries'!$J$5)+1))),ROWS($A$2:A2)))="Struck Against","X","")