(Spreadsheet application expert) Find the formula for automatic scoring of national physical fitness health test.

First, the grade columns need to be merged and filled, and then the IF function and LOOKUP function are used, as shown in figure =IF(A2= "Grade One", LOOKUP(B2, {1 1 233}, {1 1 222). {1 1, 22,33}, {11,222,333}), if (a2 = "Grade Three", look up (B2, {65433}.