|
Indirect
I am trying to decipher the following formula: Indirect(""'&Facilities&"'!f2"). John:confused: -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=519636 |
Indirect
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:confused: -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=519636 |
Indirect
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 |
Indirect
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:confused: -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=519636 |
Indirect
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:confused: -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=519636 |
Indirect
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:confused: -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=519636 |
| All times are GMT +1. The time now is 02:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com