Forum Discussion
How to assign different values to different text words in single cell?
Hello, I hope you can help me. I would like to have a different number value appear in a cell depending on what word is choosen from a drop down menu in another cell. The words with the values ...
Select the range shown in your post, from the cell with "Weak" to the cell with 0 (.e. 5 rows by 2 columns).
Click in the name box on the left hand side of the formula bar.
Type the name Scores and press Enter.
You have assigned the name Scores to the selected range.
Let's say you have a drop-down with Weak, Limited etc. in D13.
In E13, enter the formula
=IFERROR(VLOOKUP(D13,Scores,2,FALSE),"")
You can fill this down if required.
Thank you this seems to work very well 🙂