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 <[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? > > For example, I have this > > row 1: > row 2 > > > -- 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
