OK, here is the file.
test1-rj.ods <http://nabble.documentfoundation.org/file/n4144386/test1-rj.ods> Found one thing- The array defined in the vlookup should be one more then the last data row. Otherwise the last nae doesn't show. Didn't figure out why.... Amyway, hope this gives you someting to go with. Succes, Rob. -- View this message in context: http://nabble.documentfoundation.org/Calc-selecting-from-a-list-vlookup-maybe-tp4144307p4144386.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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