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!


          NL No Lunch 0.5
Date Occurrence Description Point change   T 10-60 min. Late 1
2/1/18 T Clocked in at 8:15 1   TT 61-120 Late 2
3/5/18 NL No lunch taken 0.5   LE Leave Early, unexcused 2
          TTT 2+ Hours Late, all day absence 3


By: Rosy

696 thoughts on “Enter a letter code in one cell and represented number in another cell

  1. Baixar Iptv Smart Tv

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. hentaisea.com

    This unique blog is no doubt entertaining and also amusing. I have discovered a lot of handy advices out of this source. I ad love to visit it again and again. Thanks a lot!

  3. seo yang salah

    Hello! This really is my very first visit to your site! Many of us are a team regarding volunteers and starting a fresh initiative in a group inside the same niche. The blog provided us helpful information to operate on. A person have done an exceptional career.

  4. Eura

    Nice blog here! Also your site loads up very fast! What web host are you using? Can I get your affiliate link to your host? I wish my site loaded up as fast as yours lol

  5. Selena

    thank you for all your efforts that you have put in this. Very interesting info. Truth sits upon the lips of dying men. by Matthew Arnold.

  6. Kera

    Woman of Alien Fantastic perform you might have accomplished, this page is really amazing with amazing facts. Time is God as strategy for holding almost everything from occurring at once.

  7. manfaat seo

    I feel actually pleased to have seen your own webpage and appear forward in order to so many more enjoyable times reading here. Kudos yet again for all typically the details.

Comments are closed.