On Sun, 09 Aug 2009 09:57:52 +0200, Per Jessen wrote:
Per Jessen wrote:
Jim Henderson wrote:
I don't see anything in your lookup that looks invalid, just at first glance. Is this OO2 or OO3?
I'm still on 2.4 - I was going to try it out on OO3 on a different system too though.
Just tried it on OO3.1 - same result. Some of the results are correct, whether blank or not, but others appear to have been picked at random.
One thing I note from the documentation for LOOKUP is: "Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results. If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." Are you sure you're not running into this condition? This is one reason I prefer VLOOKUP. Unless you need th eresult to come from a different column and/or row. Jim -- Jim Henderson Please keep on-topic replies on the list so everyone benefits -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org