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

Hi,

I have a list of music numbers for our choir in calc.
Each number is identified by a number in col A, and sometimes a sub-number or letter in col B.

Someting like:

296             title1  Composer        Arr.    text    publisher       
297     a       title2  C2
297     b       title3  C3
298     1       title4  C1
298     2       title5  C3              A       B       xx
299             title6  C2

This is in the lab Mainlist.

In another tab (performed)I just want to reference number and subnumber, and get the title, 
composer, arranger, etc. from the Main list.

How can I lookup 2 values set in Performed E1 and F1 in the main list?


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