Formula for expressing data in a table

[Gardener76]

Hi, I am looking for the best way to write the formula for the attached tables.

Table A, I will already have Neck Score, Leg Score and Trunk Posture Score.

Table C, I will have Score A and Score B.

Would I be correct in writing a formula like this for Table A?

IFS(
AND(CONTAINS([Neck Score], “1”),IN([Leg Score], “1”, IN([Trunk Posture Score], “1”)),1,
AND(CONTAINS([Neck Score], “1”),IN([Leg Score], “1”, IN([Trunk Posture Score], “2”)),2,
AND(CONTAINS([Neck Score], “1”),IN([Leg Score], “1”, IN([Trunk Posture Score], “3”)),2,
AND(CONTAINS([Neck Score], “1”),IN([Leg Score], “1”, IN([Trunk Posture Score], “4”)),3,
AND(CONTAINS([Neck Score], “1”),IN([Leg Score], “1”, IN([Trunk Posture Score], “5”)),4,

etc etc…

Just making sure I am not creating more work than is required and wondered if there was an easier way?

Thanks in advance, your ideas and input is always appreciated.