Thanks! That did the trick! Mark On Mon, Jan 2, 2012 at 3:14 PM, MiguelAngel <mariosv@miguelangel.mobi>wrote:
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 Phillips<mark@** phillipsmarketing.biz <mark@phillipsmarketing.biz>>wrote: Is there a way to have a text string in a cell and use that text stringin a formula for the sheet name?e For example, I have this row 1: row 2One 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%2Bhelp@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+help@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