Created attachment 54532 [details] Simple Problematic file If I have a "[" in my criteria in a vlookup funtion, it fails to find the item in the list.... "]" works fine tho, and M$ Excel works as expected. Total blocker for my project.... :(
Hi, [ is a special character. If you want to use VLOOKUP with cells containing special characters : 1. If you don't need to use them in other formulae in the same file : Turn of "enable regular expressions in formulas" in the menu Tools > Options > LO Calc > Calculate. 2. If you used them in other cells : Place the escape character \ (backslash) before with the SUBSTITUTE function. =VLOOKUP(SUBSTITUTE(C6;"[";"\[");C4:D9;2;0) The special characters are . ^ $ * + ? \ [ ( { | Regular expressions in Calc functions : http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Calc#Regular_expressions_in_Calc_functions Closed "Not a bug"