title: Wildcard reference to another workbook with INDIRECT Function
body: <p>I want to make a reference to another workbook , let's say its name is "My workbook.xlsm" with the INDIRECT Function in Excel.</p>
  
  <p>However "my workbook" file name could have any other string/characters before it or after it.</p>
  
  <p>let's say I'm Trying to lookup "Lookup Value"</p>
  
  <p>=VLOOKUP("<em>"&amp;"Lookup Value"&amp;"</em>",INDIRECT("'["&amp;"<em>"&amp;"my workbook"&amp;"</em>"&amp;".xlsm"&amp;"]"&amp;"("&amp;A7&amp;")"&amp;"'!$A:$H"),8,FALSE)</p>
  
  <p>I've tried the above formula and when i remove the wildcards before and after "my workbook" reference and write the name of the workbook exactly as it is , the formula works fine, but when i place the wildcards the formula gives a REF Error.</p>
  
  <p>I'm definitely doing something wrong.</p>
  
  <p>can anyone help please?</p>
  
  <p>thanks in advance.</p>