, Good evening.
I feel happy to help you. :)
When the problem has more possible options the IF function
is not the most efficient or better function, to solve the problem.
Use the VLOOKUP
It is more efficient and more professional and easy to maintain, as needed.
I created a small example for you.
I used in cell D1
data validation that helps a lot in time to fill in information. You do not have to keep typing it again.
Do you know Data Validation
Any doubts call again.
Belo Horizonte, Brasil