MATCH Formula, Value=0?

[Guest]

I was using this forumula, which I found in another thread here...

=IF(A2="","",MATCH(A2,{"I strongly disagree","I disagree","Neutral", "I
agree","I strongly
agree"},FALSE))


Is there any way to set your own values for what these mean? I don't want
strongly disagree to equal 1, but zero. I tried changing false to -1, but it
didn't work. What can I do to set up specific values for each option?

Thanks

 

[Max]

One way, using INDEX / MATCH:
=IF(A2="","",INDEX({0;1;2;3;4},MATCH(A2,{"I strongly disagree";"I
disagree";"Neutral";"I agree";"I strongly agree"},0)))

Above will return the values: {0;1;2;3;4}
corresponding to:
{"I strongly disagree";"I disagree";"Neutral";"I agree";"I strongly agree"}

 

[Guest]

Thank You!!!

One way, using INDEX / MATCH:
=IF(A2="","",INDEX({0;1;2;3;4},MATCH(A2,{"I strongly disagree";"I
disagree";"Neutral";"I agree";"I strongly agree"},0)))

Above will return the values: {0;1;2;3;4}
corresponding to:
{"I strongly disagree";"I disagree";"Neutral";"I agree";"I strongly agree"}

 

[Max]

You're welcome !