Re: [libreoffice-users] Re: Calc Question Regarding Sheets and Formulas
Thanks! That did the trick! Mark On Mon, Jan 2, 2012 at 3:14 PM, MiguelAngel mari...@miguelangel.mobiwrote: El 02/01/12 22:23, Mark Phillips escribió: My apologies, gmail decided to send the message before I was finished..I will try it again. A row has Jan 3, Jan 8, Jan 12, in each of three columns. These string are really formatted dates. I have three sheets with names Jan 3, Jan 8, Jan 12. I want to write a formula (vlookup) that has a reference 'Jan 3'.a1:g14, but I want the Jan 3 sheet name to be taken from the cell that has Jan 3 in it. I can then copy the formula across the spreadsheet in the row under the dates and refer to each succeeding sheet. I hope this makes sense! Thanks, Mark On Mon, Jan 2, 2012 at 2:18 PM, Mark Phillipsmark@** phillipsmarketing.biz m...@phillipsmarketing.bizwrote: Is there a way to have a text string in a cell and use that text string in a formula for the sheet name?e For example, I have this row 1: row 2 One method is use INDIRECT(TEXT(ceelwithdate;**MMM D).A1:g14) to compose the address. Miguel Ángel. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Calc Question Regarding Sheets and Formulas
My apologies, gmail decided to send the message before I was finished..I will try it again. A row has Jan 3, Jan 8, Jan 12, in each of three columns. These string are really formatted dates. I have three sheets with names Jan 3, Jan 8, Jan 12. I want to write a formula (vlookup) that has a reference 'Jan 3'.a1:g14, but I want the Jan 3 sheet name to be taken from the cell that has Jan 3 in it. I can then copy the formula across the spreadsheet in the row under the dates and refer to each succeeding sheet. I hope this makes sense! Thanks, Mark On Mon, Jan 2, 2012 at 2:18 PM, Mark Phillips m...@phillipsmarketing.bizwrote: Is there a way to have a text string in a cell and use that text string in a formula for the sheet name? For example, I have this row 1: row 2 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Calc Question Regarding Sheets and Formulas
El 02/01/12 22:23, Mark Phillips escribió: My apologies, gmail decided to send the message before I was finished..I will try it again. A row has Jan 3, Jan 8, Jan 12, in each of three columns. These string are really formatted dates. I have three sheets with names Jan 3, Jan 8, Jan 12. I want to write a formula (vlookup) that has a reference 'Jan 3'.a1:g14, but I want the Jan 3 sheet name to be taken from the cell that has Jan 3 in it. I can then copy the formula across the spreadsheet in the row under the dates and refer to each succeeding sheet. I hope this makes sense! Thanks, Mark On Mon, Jan 2, 2012 at 2:18 PM, Mark Phillipsm...@phillipsmarketing.bizwrote: Is there a way to have a text string in a cell and use that text string in a formula for the sheet name?e For example, I have this row 1: row 2 One method is use INDIRECT(TEXT(ceelwithdate;MMM D).A1:g14) to compose the address. Miguel Ángel. -- For unsubscribe instructions e-mail to: users+h...@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