Forum Discussion
Need help with my formula, please!
Trying to return a numerical value 1-5 based on the text response in the cell. It's basically an attempt to turn a Likert scale response into a number. Here's what I have so far but it's not working:...
That kind of thing is better done as a VLOOKUP
See the attached sample sheet, where J3 is a drop down that allows for the five possible answers.
J6 contains the following formula:
=VLOOKUP(J3,M3:N7,2,0)
and M3:N7 is a table that contains the texts and the associated values. You could change the wording in that table and have it automatically picked up in the wording of the drop down in J3.