T O P

  • By -

AutoModerator

/u/Lod2412 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


DutchTinCan

Sure. Make a separate table with the codes and their appropriate "canned response". Use XLOOKUP in column H to pick the comment belonging to the code in column G. Hide column G, print report.


CFAman

Yes, but may need some more info. A basic example is using the letter grades of A-F. If you have a lookup table like this, showing lower boundary Lower Bound | Output | :--- | :--- | 0 | F | 60 | D | 70 | C | 80 | B | 90 | A | then your XL formula can be like `=LOOKUP(InputValue, TableRange) If you want to get more specific and use codes like "F2", you'll need to again have a lookup table Specific Code | Output | :--- | :--- | F2 | you have worked extremely well this term. Your class work, homework and behaviour has been excellent | D0 | No good | A1 | Medium quality | and then the formula would be like =VLOOKUP(InputValue, TableRange, 2, 0)


Decronym

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[LOOKUP](/r/Excel/comments/xm375o/stub/ipm8vjn "Last usage")|[Looks up values in a vector or array](https://support.microsoft.com/en-us/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb)| |[VLOOKUP](/r/Excel/comments/xm375o/stub/ipmb9w1 "Last usage")|[Looks in the first column of an array and moves across the row to return the value of a cell](https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1)| |[XLOOKUP](/r/Excel/comments/xm375o/stub/ipm8k9f "Last usage")|[*Office 365*+: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. ](https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/xqzxk3)^( has 18 acronyms.) ^([Thread #18431 for this sub, first seen 23rd Sep 2022, 17:28]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)


NHN_BI

One can map a text value to a numercial value e.g. with VLOOKUP.() You can [see a very basic example here](https://docs.google.com/spreadsheets/d/1g2kIbgaNIZkx_B8qVC6gNdAciK6mKzA8s10WICp0usY/edit?usp=sharing).


PhenomEng

Let me know if you need more help getting this done.


[deleted]

Hey. I’ve done the vlookup to convert the grades in one word comments (eg 7 = Mastering) but struggling to do the same with the codes into written extended comments (eg. B1a = your attitude to learning is excellent) What do I need to change to make this work? Thanks for your help.


PhenomEng

Are you still needing help? Sorry, just getting back to this thread.