SoftMaker.com

English-Language Support
It is currently Tue Sep 02, 2014 12:32 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Wed Jan 07, 2009 5:20 pm 
Offline

Joined: Wed Jan 07, 2009 5:13 pm
Posts: 2
I am using the LOOKUP() formula to lookup values from column B in column A and for some reason some values are not found even though both columns contain those values.

Is there a known bug in the LOOKUP() formula that causes this or am I doing something foolishly wrong?
(by the way: I have the same problem with VLOOKUP())

Please see my screenshot for further clarification:
Image


Top
 Profile  
 
PostPosted: Thu Jan 08, 2009 9:46 am 
Offline
SoftMaker Team
SoftMaker Team

Joined: Wed Apr 09, 2008 7:26 am
Posts: 5303
Location: Nuremberg
Hello,

LOOKUP() requires the search area to be sorted in the internal sort order. Your column is not sorted, so the llookup algorithm does not return the correct result. Same happens in Excel, see the attached screenshot.

Use Table/Sort to sort the first column in the correct order.


Attachments:
bild2.JPG
bild2.JPG [ 44.1 KiB | Viewed 1127 times ]

_________________
Sven LeƟmann
SoftMaker Software GmbH
Top
 Profile  
 
PostPosted: Thu Jan 08, 2009 10:16 am 
Offline

Joined: Wed Jan 07, 2009 5:13 pm
Posts: 2
Thanks for the quick help Sven! I sorted the A column and now it's working fine! 8)

In my screenshot the A Column was also sorted, but in a different way.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group