Indirect

J

jcastellano

I am trying to decipher the following formula:

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


John:confused
 
R

Roger Govier

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" <[email protected]>
wrote in message
news:[email protected]...
 
K

Kevin Vaughn

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.
 
R

Roger Govier

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.
 
K

Kevin Vaughn

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.
 
Top