I'd like the formula to be written as lookup the name in cell B2, through range A, if there is no result, then look up the name in B2 in range B, and if no result look up the name in range C.

I have it written with SUMIFS formula, maybe that is giving me the problem? I am returning a FALSE result.

=ISNA(IFERROR(IF(VLOOKUP($B$2,PACRIMARMS19,8,FALSE)&"-"&VLOOKUP($B$2,PACRIMARMS19,9,FALSE),,SUMIFS(STATS19MiLpREG!$E$3:$E$45693,STATS19MiLpREG!$B$3:$B$45693,$B$2)&" - "&SUMIFS(STATS19MiLpREG!$F$3:$F$45693,STATS19MiLpREG!$B$3:$B$45693,$B$2)),VLOOKUP($B$2,STATS19MLpERA,3,FALSE)&" - "&VLOOKUP($B$2,STATS19MLpERA,4,FALSE)))