Alternative for Multiple If Conditions?

[zguan1]

Hello,
I am seeking help to find a way to include multiple IF conditions (51 of them) in one formula. I have outlined the background below:

I have two tables: Table 1 contains a division code for each of the 52 states. And table 2 has account names and their respective state info. I am trying to map the division code for each of the accounts based on their state in table 1. One logic I can think of is =if(State ="AK", "1.5","") OR if(State = "AL","2.3","") OR if(State="AR", "4.1","").......etc - includes all 52 states in this formula. This is just the logic, I was wondering 1) what would be the correct formula to include all the if functions in one formula? 2) is there a better way to capture what I am looking for (division code)? Thank you


 Table 1 State Division Code AK 1.5 AL 2.3 AR 4.1 AZ 5.9 CA 6.6 CO 7.5 CT 8.8 DC 10.1 DE 11.4 FL 12.7

Table 2
Account State Division Code 1 AK 2 HI 3 AK 4 HI 5 AR 6 CO 7 AR 8 CO 9 IL 10 CO

[xor]

Here is one option.

[zguan1]

Originally Posted by xor

Here is one option.

Thank you very much!