Oct 27 2021 10:29 AM
I have some survey results that come out as text that I need to transpose to a number. For example Strongly like would get a value of 5, Like - value of 4 etc.
Oct 27 2021 10:40 AM
You need to instruct Excel that "Strongly" is 5, etc. That could be a separate table (preferably) or that could be hardcoded in formulae. Another story where and how to use that, from the question it's not clear.
Oct 27 2021 10:43 AM
Oct 28 2021 03:03 PM
You may use something like
=IFERROR( INDEX( numberColumn, MATCH( textToLookup, textColumn, 0 ) ), "no such")