OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

VLOOKUP guesses unknown names

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Tue Jan 27, 2004 1:58 am    Post subject: VLOOKUP guesses unknown names Reply with quote

I ve set up a VLOOKUP which finds data on a separate sheet. It works fine but it guesses unknown names, seemingly at random.
Any ideas welcomed.
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Tue Jan 27, 2004 11:27 am    Post subject: Reply with quote

Have a look at the HELP for this function ... the "sort" parameter is likely to be the source of your problem

Quote:
Sort order is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE if the first column is not sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is between the lowest and highest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return this message: Error: Value Not Available.
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Tue Jan 27, 2004 11:32 pm    Post subject: Reply with quote

that seems like the answer.

My formula =VLOOKUP(C912;.$C$16:$D$906; 2) works ok.

the last digit 2 determines whether the info comes from col 2 ie D or col 1 ie C

any other digit gives me an err: 502 : FALSE gives me #NAME?

what should I do next?
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Wed Jan 28, 2004 2:29 am    Post subject: Reply with quote

the sort parameter is the 4th so =VLOOKUP(C912;C$16:$D$906; 2;1) or =VLOOKUP(C912;C$16:$D$906; 2;0) is the complete formula (true and false are translated on input for some reason)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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 vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group