Forum Discussion

srsmith1978's avatar
srsmith1978
Copper Contributor
Aug 16, 2022

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 ...
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Aug 16, 2022

srsmith1978 

If you list the attributes in numerical order XMATCH could be used directly

= IFERROR(
      XMATCH(selection, {"Strong";"Reasonable";"Limited";"Weak"}),
  0)

A Lambda function would tidy the functionality somewhat

WorksheetFormula
= AssignValueλ(selection)

AssignValueλ
= LAMBDA(s,
    IFERROR(
      XMATCH(s, {"Strong";"Reasonable";"Limited";"Weak"}),
    0)
  )

 

Resources