openoffice calculate difference in a cell

1 would appear before 3 in the top row, and there is no position to the left of that in the table. 7 would appear between 5 and cat, so the position to the left is found. The contents of the corresponding cell in A3:E3 are returned. In these examples, cells A1, B1, C1, D1, E1 contain 3, 5, cat, mat, matter, and cellsĪ3, B3, C3, D3, E3 contain A, B, C, D, E.

If ' Search criteria = and must apply to whole cells' is enabled on the Tools - Options - Calc - Calculate dialog, lookupvalue must match the whole text in the cell if not, it can match just part of the text. This only makes sense, and should only be used, if you expect there to be unique exact matches. Matching is always case-insensitive - the case setting on the Tools - Options - Calc - Calculate dialog does not apply.Īdvanced topics: If regular expressions are enabled on the Tools - Options - Calc - Calculate dialog, LOOKUP will find exact matches treating lookupvalue as a regular expression. If there is no exact match, the position just before where lookupvalue would appear is found the #N/A error results if that position is not in searchtable. If there is an exact match, that is the position found if there is more than one exact match, the position found is not necessarily the leftmost/ topmost. LOOKUP decides where in searchtable lookupvalue would appear. LOOKUP returns the value in resulttable in the position where the match was found in searchtable. Resulttable is a range/array of the same size as searchtable. searchtable must be sorted, with numbers in ascending order appearing before text values in alphabetic order. LOOKUP(lookupvalue searchtable resulttable) lookupvalue is a value (number, text or logical value) to look up in the single row or single column range/array searchtable. Returns a value from a single-cell-wide table, in a position found by lookup in another table.

Openoffice calculate difference in a cell