You haven't told us what value SUM(E38:E41) returns, but Excel help for the
LOOKUP function says:
"If lookup_value is smaller than the smallest value in lookup_vector, LOOKUP
gives the #N/A error value."
3.5 is > 3 and still not high enough to avoid the error state with that
formula. Also, is there some reason you're converting the responses 1-5 into
text strings by putting them in quotes? Perhaps this instead:
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.