HLOOKUP function

[tonykyte]

I have a table with data organised with the top row being in whole numbers, but the actual hlookup number I use can be part of a number e.g. 10.25, when the number is not a whole number the formula returns a error. How can I in the formula get the formula to return the information in the table to the next whole number? In the instance of 10.25 I want it to find the data relating to 11.

[XOR LX]

Hi,

Perhaps take a look at the CEILING() or ROUNDUP() function.

Regards

[tonykyte]

Thxs, but I will only want to round up if not a whole number, will this work and how do I build Roundup into the HLOOKUP function

[XOR LX]

If you could post a workbook with an example or two of what you're trying to achieve, and your desired result(s) clearly outlined, then I'm sure we'll be able to help.

Regards

[tonykyte]

I have incorporated the roundup function into my hlookup formula and this works fine, thxs

[XOR LX]

Great. Glad you got it to work.

Cheers.