One more time - substitutions

  • Thread starter Thread starter jjs
  • Start date Start date
J

jjs

I have a cell like this, call it B1
='K:\group1\[name1.xls]Survey1'!$E$8

I want what is in cell A1 substituted for "name1.xls".

A1 B1
Smith_Bob ='K:\group1\[????]Survey1'!$E$8

What would go into "????" If it is not native to Excel then I will have to
find another product.

(The A column will be a list of about 50 other Excel files. Changing the
first column entries would proliferate across the associated row of many
cells, each associated with the A1 spreadsheet. By simply entering or
changing A column entries I'd have all the data associated.)

(The linked files will not all be open.)
 
Hi
not possible with INDIRECT in Excel directly. You'll need one of the
following alternatives:
http://tinyurl.com/2c62u

So in your case INDIRECT.EXT should work.e.g.
=INDIRECT.EXT("'K:\group1\[" & A1 & ".xls]Survey1'!$E$8")
 
Back
Top