Projections.xlsx

I am trying to compile Baseball projections in excel. I have 2 sets (there used to be 3 sets; see comment at end of post*) of projections in columns B:W and Y:AT. Columns AV:CD compile these projections so that all original names are listed in Columns AV and BL and are only listed once. Currently I am using the formula

={IFERROR(IFERROR(IFERROR(INDEX(SteamerBatters,MATCH(0,COUNTIF($AV$2:AV2,SteamerBatters),0)),INDEX(ESPNBatters,MATCH(0,COUNTIF($AV$2:AV2,ESPNBatters),0))),INDEX(ZiPSBatters,MATCH(0,COUNTIF($AV$2:AV2,ZiPSBatters),0))),"")}

in columns AV (and a variant for the Pitchers in BL) which works great (I only dragged them down several rows because it slows my computer down so much. They need to be dragged down to 1300 though); the only problem is that it is slowing down my program significantly (maybe because I have to use it as array formula; though to be honest I don't know exactly what is slowing down the program). Does anybody have any ideas on how to modify or completely change my formula to speed up my program and still produce the same result? I would greatly appreciate any help as It takes at least 15-30 minutes to do anything on my spreadsheet at the moment.

*For anybody wondering I had a 3rd set of projections in my program but my excel file was too large to upload so I had to eliminate one projection set to upload it. That is why there is an additional section labeled ESPNBatters/ESPNPitchers in my formula. I guess eliminating that would bring it down to

={IFERROR(IFERROR(INDEX(SteamerBatters,MATCH(0,COUNTIF($AV$2:AV2,SteamerBatters),0)),INDEX(ZiPSBatters,MATCH(0,COUNTIF($AV$2:AV2,ZiPSBatters),0))),"")}

but I will have the 3rd projection in my final results.

Thanks