Re: [libreoffice-users] vlookup case

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 <b.m.barker@btinternet.com> wrote:

 Subject: Re: [libreoffice-users] vlookup case
 To: users@global.libreoffice.org
 Cc: "Gary Collins" <gcatlast@yahoo.co.uk>
 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: users+unsubscribe@global.libreoffice.org
 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: users+unsubscribe@global.libreoffice.org
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