Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am trying to use MATCH() and/or LOOKUP() in LibreOffice Calc. I have the "Search criteria = and <> must apply to whole cells" and the "Enable regular expressions in formulas" options selected. The item I am looking for is a multi word string.

How do I provide a search criteria as a cell reference (E3) in to LOOKUP(E3, B1:B20, C1:C20) and have it match the value in B1:B20 EXACTLY? Right now it is matching partial strings rather than matching the cell values exactly.

share|improve this question

1 Answer 1

up vote 3 down vote accepted

Even if it is a late answer, I've had difficulties myself to accomplish what OP asked, so just for the record:

Go to "Tools - Options - LibreOffice Calc - Calculate" and:

  • switch on the option "Search criteria = and <> must apply to whole cells".

  • switch off the option "Enable regular expressions in formulas" if you have cell contents with () or other characters which are interpreted as regular expressions. Taking this option off causes the comparison to be performed against full exact text.

Hope it helps.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.