[libreoffice-users] Simple address data and 3 sheets

I am trying to keep a spreadsheet file as simple as possible for a group 
of musicians who have very little to no knowledge of how a spreadsheet 
functions.

So, in the spreadsheet, I have:

* Sheet1: has a list of names, in a column, that will change monthly 
describing how long each musician played in a second column. A musician 
"general manager" would input the musicians names once a month. This 
list would change every month and would have different combinations of 
names depending on whether they were hired to perform or not.

* Sheet2: has a column where it lists the musicians' names who performed 
by referencing the corresponding name cells to the Sheet1 name cells, 
BUT, Sheet2 has to have their addresses show in a set of cells that 
mimics an address book (similar to Thunderbird address book)

* Sheet3: has ALL the lists of the musicians' names, addresses laid out 
like an address book similar to Thunderbird (simple to put together for 
any user)

I was wondering if there was an elegant way of doing the following:

Sheet2 would need to find the corresponding name from each name cell on 
Sheet1 and then look up the correct name on Sheet3 simple address book. 
The musicians data in the Sheet3 address book would then fill in the 
cells on Sheet2

My solution thus far:

* create a series of "if" arguments that would check each name in the 
name cell in Sheet2 until it finds the same name and then, once the "if" 
argument is satisfied, would then fetch the address data from Sheet3 
simple address book and populate the cells on Sheet2


My question is ... Is there another simpler or more elegant way of 
accomplishing this process? Is there another argument I could use to do 
this?

Thanks for the help.

Marc



--
Marc Paré
Marc@MarcPare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


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