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!
Key | |||||||
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
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.
Usually I don at read article on blogs, but I would like to say that this write-up very pressured me to check out and do it! Your writing style has been amazed me. Thanks, very nice article.
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.
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!
I cannot thank you enough for the article.Thanks Again. Great.
I wish to express appreciation to the writer for this wonderful post.
I value the post.Really thank you! Cool.
Woh I love your content, saved to bookmarks!
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.
I value the post.Really looking forward to read more.
Ridiculous story there. What happened after? Thanks!
I’ve book-marked your site, and I am just adding your The rss or atom feeds to my Search engines account.
Va Alcohol Treatment Drug Rehab Facilities Near Me ÿþ< Polysubstance Abuse Dsm 5 Local Drug Treatment Centers
ÿþh
Very good information. Lucky me I recently found your website by accident (stumbleupon). I ave bookmarked it for later!
Inpatient Drug And Alcohol Rehab Substance Abuse Prevention And Treatment Program ÿþ< Rehabs That Take Medical Substance Abuse Help
ÿþh
I was recommended this web site by my cousin. I am not sure whether this post is written by him as no one else know such detailed about my problem. You are amazing! Thanks!
Incredible points. Sound arguments. Keep up the great spirit.
Long Term Drug Rehab Near Me Drug Abuse Rehabilitation ÿþ< Faith Based Rehab Near Me Best Rehab Near Me
ÿþh
Wow, marvelous blog layout! How long have you been running a blog for? you made running a blog look easy. The overall glance of your site is excellent, as well as the content material!
Thanks for the info
Wow, great article.Much thanks again. Much obliged.
Very interesting points you have observed , regards for putting up. It is seldom that liberty of any kind is lost all at once. by David Hume.
Really excellent info can be found on website. Never violate the sacredness of your individual self-respect. by Theodore Parker.
Long Term Inpatient Drug Rehab Free Drug Rehab ÿþ< Substance Abuse In Children Rehabilitation Of Substance Abuse
ÿþh
You have observed very interesting points ! ps decent website. There as always one who loves and one who lets himself be loved. by W. Somerset Maugham.
I just wanted to compose down a quick term to say thanks in order to you for all those wonderful ideas and hints you might be displaying on this site.
Thank you for some other informative blog. Where else could I get that type of information written in such an ideal means? I have a mission that I’m just now working on, and I have been at the look out for such information.
Alcohol Inpatient Journeypure Rehab ÿþ< Alcohol Treatment Free Alcohol Rehab Near Me
ÿþh
I’m gone to say to my little brother, that he should also pay a visit this website on regular basis to obtain updated from newest gossip.|
Some genuinely nice and useful information on this website, besides I think the pattern has wonderful features.
You are my inhalation , I own few web logs and occasionally run out from to post.
There as certainly a great deal to learn about this issue. I like all the points you ave made.
Very well written story. It will be valuable to anyone who usess it, including yours truly . Keep up the good work – can’r wait to read more posts.
niche. Your blog provided us valuable information to work on.
Alcohol Rehab Substance Abuse Alcohol ÿþ< Best Drug Treatment Centers Alcohol Abuse Treatment
ÿþh
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
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.
If you were a box of crayons, you’d be the big industrial name-brand one with a built-in sharpener.
Substance Abuse Center Best Inpatient Rehab ÿþ< Substance Abuse Services Near Me Women'S Rehab Center Near Me
ÿþh
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.
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.
Very informative blog article.Much thanks again. Keep writing.
Some times its a pain in the ass to read what blog owners wrote but this web site is real user genial !.
I loved your blog.Really looking forward to read more. Really Great.
very cooperative and hence simple to do. i just spent as a result much mature browsing for results on the other hand of coming here since
Thank you a great deal for providing individuals using an extremely spectacular possibility to be able to read critical reviews coming from this site.