||06-06-2007 06:04 AM
openoffice calc LOOKUP() returns wrong value
I have a document that among other things takes a string from one cell, looks it up in another sheet, and returns the corresponding number value. for some reason, some of the values seem to match incorrectly. the search vector is quite long, but there are no doubles. e.g. when searching for "molle05", the value for "marked20" is returned. I have sorted the search vector, and the function should be correct, since mostly the return values are correct.
the function looks like this: 'LOOKUP($D58;$priser.$A$3:$A$577;priser.C$3:C$577)'