MySQL Forums
Forum List  »  MySQL for Excel

Equivalent to Excel vlookup
Posted by: Alan Murrell
Date: November 20, 2011 01:16PM

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.

Options: ReplyQuote

Written By
Equivalent to Excel vlookup
November 20, 2011 01:16PM
November 20, 2011 01:40PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.