MySQL Forums
Forum List  »  MySQL for Excel

Advanced Search
New Topic

Re: Equivalent to Excel vlookup
Posted by: Peter Brawley
Date: November 20, 2011 01:40PM

One method:

select points
from tbl
where value_1-0.64 = ( select min(abs(value_1-0.64)) from tbl );

PB

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Equivalent to Excel vlookup
4179
Alan Murrell
November 20, 2011 01:16PM
Re: Equivalent to Excel vlookup
1803
Peter Brawley
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.