VLOOKUP function not working with table

**conphill** · 02-28-2011, 11:37 AM

I am trying to use my vlookup function to give each person a percentage based on where their points are within the range. It seems that I get an error when I try to use the function. My function is in H5, and using the table on the second part of sheet 1.

**daddylonglegs** · 02-28-2011, 11:45 AM

The lookup range needs to be numeric (in most circumstances)....and in ascending order so if you make F53:F57 these values

0, 17, 20, 22, 24

and then in G53:G57

45%, 50%, 65%, 90%, 95%

Then in row 5 copied down you can use this formula

=LOOKUP(F5,F$53:G$57)

**conphill** · 02-28-2011, 12:40 PM

Originally Posted by daddylonglegs

The lookup range needs to be numeric (in most circumstances)....and in ascending order so if you make F53:F57 these values

0, 17, 20, 22, 24

and then in G53:G57

45%, 50%, 65%, 90%, 95%

Then in row 5 copied down you can use this formula

=LOOKUP(F5,F$53:G$57)

Thanks. This is what I was looking for