How to populate a field depending on the contents of a cell?

Question

excel

How can I automate the filling of the second table (highlighted in red, already filled)?



There is an initial table and there is a cipher, for example, SrS is converted to the number 7. Is it possible to somehow quickly fill in encrypted tables without prescribing 20 conditions?

Answer 1

Alternatively, you can use the formula vlook()
For your example, In cell g2, write =vlook(b2;$l$2:$m$21;2;0) and stretch the formula over the entire GL range