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 Phillips<mark@phillipsmarketing.biz>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: 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