Wait, I found it, I needed to turn off regular expressions in formulas. http://www.openoffice.org/issues/show_bug.cgi?id=70964
Phil. -- Don't you just hate self-referential sigs? On 17 October 2010 22:20, Phil Hibbs <[email protected]> wrote: > VLOOKUP appears not to work if the value that it is looking for contains > parentheses, any idea if there is a way to fix this? I have some strings > that contain parentheses, and I need to look up translations in a table. > Google Docs (and Excel) do this just fine, OOo says #N/A. > > Phil. > -- > Don't you just hate self-referential sigs? >
