At 06:01 18/11/2015 -0600, Jorge RodrÃguez wrote:
Thank you for your support, ...
No probs!
I just order both matrix alphabetically and I tried to use VlookUp but it gave me a several false-positive as you told me.
If you get false matches from a simple VLOOKUP(), it is possible that you have not set the fourth parameter correctly. If, as here, there may not be a match, you need to set the SortOrder parameter to FALSE or zero, irrespective of whether the list is sorted.
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
