title: Using the Concatenating of an apostrophe and the reference of a cell inside the INDIRECT function
body: <p>i have one particular question about this case of concatenation(<strong>shown on the picture 1</strong>, if you can't see it, the content that i want to show with it is: <strong>=VLOOKUP(C3;INDIRECT(" ' "&amp;B3&amp;" '!B3:C7");2;FALSE)</strong>). I was practicing the VLOOKUP function,using the indirect function inside it, and at some point, along with the indirect function arguments, it was used as a reference one cell that doesn't belong to the same sheet that the function VLOOKUP was being used. So to reference this cell, to make a dynamic reference and in order to concatenate the apostrophe of the name of the other sheet with the dynamic reference cell, i saw a video of a guy using the syntax that i'll attach as an image along with this question.</p>
  
  <p>After this long text, my question is how this syntax works? I learned that to concatenate something on excel with the <strong>&amp;</strong>, i just need to use the <strong>&amp;</strong> before the stuff that i want to concatenate. But in the <strong>case shown on the attachment 1</strong>, it's used some " then a ' and then ", resulting in this shape " ' ";  so came the &amp; and after the reference of the cell, it was used the &amp; " and the '. I don't know if i was clear enough on my question. But can someone explain to me this thing? I cannot see the need of this kind of use of the &amp;, neither the need of using this " repeteadly on the indirect function. The name of the sheed that i intend to emulate with the indirect function, and the reason of the need of the apostrophe is shown on the <strong>picture 2</strong>(if is not easy to see on the pic, it is <strong>='Branch 1'!B3</strong>).</p>
  
  <p>enter image description here
  Thanks guys!</p>