Description of problem: I have a spread sheet, I cannot share it. It is to do a voting for a family matter. a2:a7 contain the options. J column is least evil (each family member votes 1 to X with 1 being best). J is the sum. K is the Yes votes (=1). L is no votes (> 3 as the order). Least Evil should work =lookup(min(j2:j7); j2:j7; a2:a7). K is the same but k instead of J and max instead of min. L is j->l but min. This works for some values, but then fails to work. I do not know if lookup uses match internally, but I get the same results when I do a similar setup without lookup with match (third value 1 or missing). If I change match to 0 with a similar setup, without lookup, it works fine. =INDIRECT("a" & (MATCH(MIN(J2:J7);J2:J7;0)+1)) Works just fine. Anyway, lookup is broken. (16, 26, 11, 21, 7, 16 being the values in J that will show it being broken). Version-Release number of selected component (if applicable): openoffice.org-calc-3.2.0-12.14.fc13.x86_64 openoffice.org-calc-core-3.2.0-12.14.fc13.x86_64
Oh, failing to function is =#N/A or something like that.
This is probably the same as bug 494741, i.e. "the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results" *** This bug has been marked as a duplicate of bug 494741 ***