How to concatenate cell value in formula having filepath.

  • Thread starter Thread starter saravan
  • Start date Start date
S

saravan

How to concatenate cell value in formula having filepath.

Cell B4 has the formula
='C:\prj\[123.xls]Sheet1'!$A$1

Cell A4 has the value
prj

Required kind of formula
='C:\ & A4 & \[123.xls]Sheet1'!$A$
 
Hi
See INDIRECT function to concatenate your reference :
=INDIRECT("'C:\" & A4 & "\[123.xls]Sheet1'!$A$1")
HTH
Cordially
Pascal
 
If the workbook is closed, then the =indirect() won't work.

Harlan Grove wrote a UDF that allows you to retrieve values from a closed
workbook when you build that string that points at the
drive/folder/filename/sheetname/range address.

http://www.google.com/[email protected]
How to concatenate cell value in formula having filepath.

Cell B4 has the formula
='C:\prj\[123.xls]Sheet1'!$A$1

Cell A4 has the value
prj

Required kind of formula
='C:\ & A4 & \[123.xls]Sheet1'!$A$1
Click to expand...
 
Back
Top