Enter a letter code in one cell and represented number in another cell

I will do my best to explain what I’m looking for – I hope it makes sense! I have included a bit of my worksheet so you can hopefully understand easier. As you can see I have a table of information and a Key to explain what abbreviations mean and the point values. Ideally, I would like to be able to type in the abbreviation in the “Occurance” column and have a formula or function set up to automatically enter the point value in the “Point Change” Column. I have already assigned a new name for each abbreviation so that when I type “=NL [Enter]” in the “point change” column it automatically changes to the coresponding point value for “NL” or “No Lunch”, but I still have to type “NL” in the “occurence” column. Is there a way to get this function to happen in one step? Maybe even typing “=NL [Enter]” into the “point Change” column and having the code “NL” automatically entered into the “Occurance” column? I would like to find some way to get it to one step where I enter the information once and the points and abbreviation are automatically inserted in their places. I feel like Excel has a way to do this and I just don’t know how to get it to happen. Thank you for your help!

By: Rosy