MATCH Formula, Value=0?

A

Anonymous

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
 
M

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"}
 
A

Anonymous

Thank You!!!

Max said:
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"}
Click to expand...
 
Top