Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Workbook Naming

6 views
Skip to first unread message

Ed McCormck

unread,
Dec 19, 2013, 10:26:49 PM12/19/13
to

Using the following formula to indirectly access a worksheet from
another one.
=VLOOKUP("US Navy",INDIRECT("'"&A32&"'!$H$7:$V$209"),15,FALSE)
Cell A32 is eon: Long timescale dynamics
Of course because of the : I cant name a worksheet with this name, is
there a way around this, first time I ran into this problem

I didn't name it that, I import the names from the web for BOINC
projects and this is one they named that way.




--
Ed McCormck

Ron Rosenfeld

unread,
Dec 22, 2013, 8:50:47 AM12/22/13
to
You'll need to determine they created a worksheet with that name in the first place.

Neither MS Excel nor Apache OpenOffice will accept colons as a worksheet name.

Ron Rosenfeld

unread,
Dec 22, 2013, 8:52:01 AM12/22/13
to
On Sun, 22 Dec 2013 08:50:47 -0500, Ron Rosenfeld <r...@nospam.net> wrote:

>On Fri, 20 Dec 2013 03:26:49 +0000, Ed McCormck <bREMVETIS...@mal.com> wrote:
>

>You'll need to determine they created a worksheet with that name in the first place.
>

Typo: Should read:

You'll need to determine HOW they created a worksheet with that name in the first place.
0 new messages