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 ...
Thanks for reply but these 2 do not seem to work.
Let me explain what I need.
I have spreadsheet. In left column I have a drop down menu from which you can select Weak, Limited, Reasonable etc. I want to assign each word a specific value which id like to appear in the next cell on the row. See mockup below: -
Ive tried Nested IF formula with also no luck.
Is there another way?
=IFERROR(INDEX($F$2:$F$6,MATCH(A2,$E$2:$E$6,0)),"")You can try this formula for the data layout of the example file. This formula is easier than nested IF. The dropdowns are in range A2:A6 in the example and the formula is in range B2:B6.
