Per Jessen wrote:
It seems straight forward (I'm not exactly a spreadsheet wizard), but I seem to be getting random/invalid lookups. Just wondering if anyone else had played with it?
thanks Per
Could be an issue with formatting, ie the number you're looking up is actually stored as text rather than as a number. The lookup-type functions are particularly sensitive to that. If that's the problem, setting the right formatting (Format cells > Numbers) then using Text to Columns (under the Data menu) should reset the formatting and fix the problem. Alternatively, your data may just have spaces in spots you don't expect. If you want a second set of eyeballs, you can send me the file off list and I'll take a look. Nkoli -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org