I am trying to decipher the following formula:

Indirect(""'&Facilities&"'!f2").


John


--
jcastellano
------------------------------------------------------------------------
jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986
View this thread: http://www.excelforum.com/showthread...hreadid=519636

Hi John

It is concatenating the single quote ' with a name and then another
single quote plus the cell reference.
If a Sheet name has spaces then it has to be enclosed within single
quotes e.g. ' My Sheet'!A1

If instead of Facilities, a cell held the Sheet name, and that sheet
name had spaces within it, then this formula would give the required
format
Indirect(""'&A1&"'!f2").

As it happens, for just what you have show, it would work just as well
with
=Facilities!F2


--
Regards

Roger Govier


"jcastellano"
wrote in message
...

I am trying to decipher the following formula:

Indirect(""'&Facilities&"'!f2").


John


--
jcastellano
------------------------------------------------------------------------
jcastellano's Profile:
http://www.excelforum.com/member.php...o&userid=30986
View this thread:
http://www.excelforum.com/showthread...hreadid=519636

Thanks for the help.:)


--
jcastellano
------------------------------------------------------------------------
jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986
View this thread: http://www.excelforum.com/showthread...hreadid=519636

I have a different take on it. However, you did not actually copy paste the
formula did you? It appears to me that facilities is a named range (named
formula) that holds the sheet name. But I bet the single quote is inside the
2 double quotes.
--
Kevin Vaughn


"Roger Govier" wrote:

Hi John

It is concatenating the single quote ' with a name and then another
single quote plus the cell reference.
If a Sheet name has spaces then it has to be enclosed within single
quotes e.g. ' My Sheet'!A1

If instead of Facilities, a cell held the Sheet name, and that sheet
name had spaces within it, then this formula would give the required
format
Indirect(""'&A1&"'!f2").

As it happens, for just what you have show, it would work just as well
with
=Facilities!F2


--
Regards

Roger Govier


"jcastellano"
wrote in message
...

I am trying to decipher the following formula:

Indirect(""'&Facilities&"'!f2").


John


--
jcastellano
------------------------------------------------------------------------
jcastellano's Profile:
http://www.excelforum.com/member.php...o&userid=30986
View this thread:
http://www.excelforum.com/showthread...hreadid=519636

Hi Kevin

I did copy and paste The OP's formula in doing my reply showing the
addition of a cell in the formula.
I had not noticed that the single quote was outside of the pair of
double quotes, rather than within as it should be.

--
Regards

Roger Govier


"Kevin Vaughn" wrote in message
...
I have a different take on it. However, you did not actually copy
paste the
formula did you? It appears to me that facilities is a named range
(named
formula) that holds the sheet name. But I bet the single quote is
inside the
2 double quotes.
--
Kevin Vaughn


"Roger Govier" wrote:

Hi John

It is concatenating the single quote ' with a name and then another
single quote plus the cell reference.
If a Sheet name has spaces then it has to be enclosed within single
quotes e.g. ' My Sheet'!A1

If instead of Facilities, a cell held the Sheet name, and that sheet
name had spaces within it, then this formula would give the required
format
Indirect(""'&A1&"'!f2").

As it happens, for just what you have show, it would work just as
well
with
=Facilities!F2


--
Regards

Roger Govier


"jcastellano"

wrote in message
...

I am trying to decipher the following formula:

Indirect(""'&Facilities&"'!f2").


John


--
jcastellano
------------------------------------------------------------------------
jcastellano's Profile:
http://www.excelforum.com/member.php...o&userid=30986
View this thread:
http://www.excelforum.com/showthread...hreadid=519636

Sorry, when I said you, I should have said the OP. I didn't mean you had
copied the formula incorrectly, I was questioning whether the OP had actually
copied it from the spreadsheet in question or whether they had typed it in.
Otherwise, I believe the quote would have been in the correct place. Again,
I apologize for the confusion.
--
Kevin Vaughn


"Roger Govier" wrote:

Hi Kevin

I did copy and paste The OP's formula in doing my reply showing the
addition of a cell in the formula.
I had not noticed that the single quote was outside of the pair of
double quotes, rather than within as it should be.

--
Regards

Roger Govier


"Kevin Vaughn" wrote in message
...
I have a different take on it. However, you did not actually copy
paste the
formula did you? It appears to me that facilities is a named range
(named
formula) that holds the sheet name. But I bet the single quote is
inside the
2 double quotes.
--
Kevin Vaughn


"Roger Govier" wrote:

Hi John

It is concatenating the single quote ' with a name and then another
single quote plus the cell reference.
If a Sheet name has spaces then it has to be enclosed within single
quotes e.g. ' My Sheet'!A1

If instead of Facilities, a cell held the Sheet name, and that sheet
name had spaces within it, then this formula would give the required
format
Indirect(""'&A1&"'!f2").

As it happens, for just what you have show, it would work just as
well
with
=Facilities!F2


--
Regards

Roger Govier


"jcastellano"

wrote in message
...

I am trying to decipher the following formula:

Indirect(""'&Facilities&"'!f2").


John


--
jcastellano
------------------------------------------------------------------------
jcastellano's Profile:
http://www.excelforum.com/member.php...o&userid=30986
View this thread:
http://www.excelforum.com/showthread...hreadid=519636