IF function With Hlookup returning wrong data

jenniferlaudine · Newbie Joined: 08 Dec 2011 Posts: 1

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.

gerard24 · Posted: Thu Dec 08, 2011 12:53 pm Post subject:

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