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