Hello,

I have 3 columns, the first with a rating of 1-10 in each row, the second is
blank and the trird has a description for the rating. When someone picks a
rating they place a "1" in the second row cell next to the 1-10 rating. I
would like the cell at the bottom of the second row to look at all the cells
and see which one has a 1 in it and then look to the cell to the left and
report that number. What formula doe this?

Example:

A B C
1 .5 Day
2 1 day
3 2-3 Days
4 4-6 Days
5 7-8 Days
6 2-3 Weeks
7 3-4 Weeks
8 1 4-6 Weeks
9 5-8 Weeks
10 More than 8 weeks
8 Total Points