Hi Rob
Rob wrote > How can I lookup 2 values set in Performed E1 and F1 in the main list? I believe it is not possible to lookup in two columns. The best way is to create a combined search field in column C of the Mainlist something like =A1&"_"&B1 On the Performed tab you can either do the same (have 3 columns) or a single column with just the combined code e.g. 297_b and do the lookup from the Mainlist If someone knows a more elegant/efficient way I would also be interested in learning. Hope this helps. Pedro -- View this message in context: http://nabble.documentfoundation.org/LOOKUP-with-2-values-in-2-columns-tp4150874p4150884.html Sent from the Users mailing list archive at Nabble.com. -- 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
