is TEXT function appropriate?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DaveMoore - 30 Jan 2008 08:02 GMT

My spreadsheet has many worksheets (tabs) labelled like (e.g.)
61900003.
There is also a Summary worksheet with a column (D) containing all
those worksheet names. In an adjoining column (E) I wish to enter a
formula like ='61900003'!L5 with the worksheet name being gained from
pointing at column D.
that sounds as clear as mud! Perhaps my forlorn attempt will help.
='TEXT(D16,text)'!L5

Can anyone help?
my thanks in advance,
Dave Moore

Reply to this Message

Harlan Grove - 30 Jan 2008 08:15 GMT

DaveMoore <david.mo...@uuplc.co.uk> wrote...

>My spreadsheet has many worksheets (tabs) labelled like (e.g.)
>61900003.
[quoted text clipped - 4 lines]
>that sounds as clear as mud! Perhaps my forlorn attempt will help.
>='TEXT(D16,text)'!L5

...

You need to use the INDIRECT function. Try replacing your formula
above with

=INDIRECT("'"&D16&"'!"&CELL("Address",L5))

Reply to this Message

David Biddulph - 30 Jan 2008 08:29 GMT

=INDIRECT("'"&D16&"'!L5")

Signature

David Biddulph

> My spreadsheet has many worksheets (tabs) labelled like (e.g.)
> 61900003.
[quoted text clipped - 8 lines]
> my thanks in advance,
> Dave Moore

Reply to this Message