http://openoffice.org/bugzilla/show_bug.cgi?id=105946
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from [email protected] 2011-07-16 21:03:41 --- I have this issue to in Windows 7. But the key I noted is that the Min result is not the first possible result in the search area. In other words there is a bigger number before the Lowest in the Min function search range. first-a1 second-b1 56-a2 12-b2 a3=Min(a2:b2) is 12 but b3=LOOKUP(a3;a2:b2;a$1:b$1) gives #N/A error instead of "second", but if 12 is first no problem mon! Erroneous errors exasperate. -- Configure bugmail: http://openoffice.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Bugzilla. Please log into the website and enter your comments. --------------------------------------------------------------------- -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
