Thanks! That did the trick! Mark
On Mon, Jan 2, 2012 at 3:14 PM, MiguelAngel <[email protected]>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 <[email protected]>>wrote: >> >> 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: [email protected].** > org <users%[email protected]> > 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: [email protected] 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
