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

IF function With Hlookup returning wrong data

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


Joined: 08 Dec 2011
Posts: 1

PostPosted: Thu Dec 08, 2011 10:09 am    Post subject: IF function With Hlookup returning wrong data Reply with quote

I have a spreadsheet that I am using an IF Hlookup function in; here is the formula
=IF(order1>1;HLOOKUP(order1;Formual;2);0)
It works perfectly to return the value if I enter 200 In box "order1" but if I enter 2115 it returns the information for 2030, Can anybody help me with this. I need it to return the exact product information corresponding to the number in the order1 box.

It seems to work great with all of the 3 digit product numbers but returns false info on the 4 digit product numbers.

If anyone knows how to solve this please let me know.
Back to top
View user's profile Send private message
gerard24
OOo Enthusiast
OOo Enthusiast


Joined: 08 Jul 2011
Posts: 100
Location: France

PostPosted: Thu Dec 08, 2011 12:53 pm    Post subject: Reply with quote

Using HLOOKUP with 4th parameter missing (or =0) needs 1st row of the range ("Formual") to be sorted in ascending order.
_________________
LibreOffice 3.5.0 on Windows Vista
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