Equivalent to Excel vlookup

[Alan Murrell]

I have a an Excel spreadsheet that calculates a value then performs a VLOOKUP on a table to find a point value. For example, the table looks like this:

  | Value_1 | Points |
  |   0.60  |    1   |
  |   0.65  |    2   |
  |   0.70  |    3   |

And if the calculated value is 0.64, then it would return a "point value" of "2". I could fill in the table values with all the "in between" values in the "value_1" column, but I would rather not as it is actually a large table.

What would be the query I would use in MySQL to do the same thing? (I already know how to do the calculation necessary to get the value). I was reading somewhere on here that a JOIN is the equivalent to VLOOKUP, but I am not trying to match values in two different tables.

Thanks, in advance.