Dave Liesse has written on 2/10/2014 4:00 PM:
The first problem I see is that your lookup value -- in this case the ID number -- has to be the first column in the lookup array.
When I moved the ID number to the first column, my VLOOKUP worked! Where does it say that that is a requirement? -- To unsubscribe e-mail to: email@example.com 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