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 ...
=INDEX($B$2:$B$6,MATCH(D2,$A$2:$A$6,0))You can try this formula for the data layout of the example. The dropdown is in cell D2.