Mar 05 2019 01:21 PM
I need help with my excel spreadsheet. I am trying to use match and index and I cannot seem to get it to work. I have a column with numbers ranging between 1 and 100. I need a second column to look at the number then match it up and give that number a rating. so if the number is 84.29 then it would return a 1 in the other column and so on. I have included a sample sheet.
Mar 05 2019 02:05 PM
If you update a bit the definition of the ranges like here
the formula is
=LOOKUP(E5,$A$4:$C$4,$A$2:$C$2)
Mar 05 2019 09:41 PM