SWITCH with baseball

In baseball, each position is provided a number from 1 through 9; 1 for the pitcher, 2 for the catcher and so forth.

While a VLOOKUP() function can be used to get this information, a SWITCH() function removes the need to create a lookup table. Your job is to create a SWITCH() function that provides the same value as the VLOOKUP() function. The first 6 positions have already been created. Your job is to fix the formula for the final 3 positions and correct the #N/A values.

Once you've successfully created the function in C4, copy it down to C12 to verify that you're getting the same values.