[Solved] Lookups don't search all values

Discuss the spreadsheet application

[Solved] Lookups don't search all values

Postby paladin++ » Sun May 05, 2019 5:38 pm

Whether I am using a vlookup or just lookup it seems that at least one of the values is not shown, and it's usually the one I need. I have even tried sorting the 1 column in both ascending and descending and the value I am looking for does not end up in the result. I use a cell to find the max value of the dates in a column, then referencing this cell I find the dollar value related to that date in a second column. BUT, when I run the lookup it finds the second highest value, not the highest.

Any help is appreciated.
Last edited by robleyd on Mon May 06, 2019 1:31 am, edited 2 times in total.
Reason: Tagged [Solved] [robleyd, Moderator]
Retired Techie
User avatar
paladin++
 
Posts: 7
Joined: Thu May 14, 2015 3:45 am

Re: Lookups don't search all values

Postby Villeroy » Sun May 05, 2019 5:56 pm

It is the same LOOKUP since Visicalc of 1979 which was the first spreadsheet ever. Because this is not the lookup function most users expect, someone added the MATCH, HLOOKUP and VLOOKUP functions with different modes of operation. By default all these functions do NOT work as most users would expect because most users misuse spreadsheets as poor man's database.
[Tutorial] VLOOKUP questions and answers
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26968
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Lookups don't search all values

Postby paladin++ » Sun May 05, 2019 10:02 pm

Thanks for the quick response. Now how do I mark this as closed?
Attachments
Learning Lookup.ods
(13.63 KiB) Downloaded 7 times
Retired Techie
User avatar
paladin++
 
Posts: 7
Joined: Thu May 14, 2015 3:45 am

Re: Lookups don't search all values [closed]

Postby RusselB » Mon May 06, 2019 1:28 am

Information for marking a topic as closed, or as we prefer to call it, Solved, is in Villeroy's signature as well as mine.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5282
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests