Going beyond 7 Nested If Arguments

Hi
My apologies for what I’m sure this must be a well worn question, but I cant seem to find an answer in old threads.

Im needing to achieve what an 11 argument nested if would manage, ie:

M   A   N    O   H   S   L   U   12   12D   12N   
7   7   10   0   0   0   0   0   12   12    12

Col E of the spreadsheet houses a total of 365 entries of a combination of the above 11 letters/numbers shown in the top line. Depending on the letter, the corresponding value needs to appear in Col N.

I’ve heard of Case If statements, but wouldn’t know how to implement them. I’d be grateful for any sort of assistance.

Many Thanks

Supdem