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

2015-06-08 Thread Pedro
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

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

2015-06-08 Thread Andreas Säger
Am 08.06.2015 um 15:03 schrieb Rob Jasper: Agh, I should have thought of this myself. Simple and elegant... A database would be simple and elegant. A spreadsheet lookup is a dirty work-around at best. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?