Thanks for very helpful reply. It does seem to be a big drawback with these functions. I'll certainly try it but ive found a workaround that im using at the mo: ive defined two strings in adjacent cells and using string functions to find the position of a character in one string then extract the corresponding character from the other. Much less elegant and it was quite tiresome to implement but ive at least got it to work, in the limited cases that im using it so far. If i extend it to transliterate strings of arbitrary length (for now the max length ive needed is 3 chars) then i guess i'll probably have to get into macros. Thanks G. -------------------------------------------- On Thu, 9/3/17, Brian Barker <[email protected]> wrote:
Subject: Re: [libreoffice-users] vlookup case To: [email protected] Cc: "Gary Collins" <[email protected]> Date: Thursday, 9 March, 2017, 23:17 At 11:50 09/03/2017 +0000, Gary Collins wrote: >Is it possible to make the search performed by vlookup to be case sensitive? Apparently not! >I need to be able to distinguish between eg 'd' and 'D' but at the >moment i cant work out how to do it (if it's possible) Suppose your array has the values to be searched in column A and the values to be returned in column B. Then try: =INDEX(B1:Bn;MATCH(1;EXACT("text";A1:An);0)) Note that this is an array formula, so when you have entered it you must complete the process by pressing Ctrl+Shift+Enter. If you do this successfully, the entire formula will appear in the Input line surrounded by braces, but you cannot simply type these braces yourself. This relies on EXACT() being the one function that *is* case-sensitive. I trust this helps. Brian Barker -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
