Harlan Grove wrote...
....
=IF(BP!S19=25,Cards!D25,
IF(BP!S19=26,Cards!D26,
IF(OR(BP!S19={27,28,29,30,31,32}),INDEX(Cards!J1: J6,BP!S19-26),0))))))))

I should know better than just to cut & paste. Too many right
parentheses above. Make it

=IF(BP!S19=25,Cards!D25,
IF(BP!S19=26,Cards!D26,
IF(OR(BP!S19={27,28,29,30,31,32}),INDEX(Cards!J1:J 6,BP!S19-26),0)))