[libreoffice-users] Re: LOOKUP with 2 values in 2 columns

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: 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