Lookup help

[doublea17]

I have a list with 2 columns. The first column has a number, 1 through 15, and the second column has a corresponding attribute. This is for an evaluation. So if the coach marks a 1, I want excel to automatically put in "Passes Forward". In the example attached the numbers are in column A and the attributes in Column B. Starting in C19 I have the evaluations and I would like D19 to show the attribute. I tried a simple SUMIF but it doesn't return the text. Is there a way to return text?

That is my main issue but also if it is possible, I would like it to return more than one if warranted. See C22. In D22 I would like it to list Passes Forward, Attitude, Communication.

[etaf]

try using
=VLOOKUP(C19,$A$2:$B$16,2,FALSE)

[doublea17]

That worked great! Any idea on how to do it if there are multiples?

[etaf]

that will be a little more difficult, as we don't know how many are entered, what they will be separated by

what are the possible multiples ?

[doublea17]

Yeah, we could separate them by whatever makes it work the easiest. The range varies as one could include all 15 numbers while others have only 3 or 2. I figured it wouldn't be a simple fix.

[etaf]

not sure how the best way would be to go about that.