LOOKUP result vector error

[shane23]

I have an issue with a LOOKUP function where the result vector is showing an incorrect value, but only for a specific lookup vector. There are 66 rows in the table but only one row has the incorrect value.

The value are related to time.

Cheers

 

[shane23]

So did you try my suggestion in Post #3 ?

Hi Alex,
Thank you also for your suggestion on the ROUND function. I am not familiar with this but will update the formula as i'd love to be able to use this!

Regards.

 

[Alex Blakenburg]

Let us know if you need help with it and @awoohaw or I can step you through it.
Any calculation can introduce floating point errors which normally isn't a big issue until you try to use it in a lookup or a comparison formula.
Since time is stored as a decimal number (fraction of a day), it is particularly prone to having the issue.