Concantenate

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

I would like to use a command such as vlookuo to lookup a value and insert
that value into a path that will identify a referenced spreadsheet. Can
that be done?

i.e. find a string in a cell and use that string as part of a file name.
 
Chuck
Yes. Within the call of the file name put something like:
& Range("A1").Value &
HTH Otto
 
In my cell formula, I substituted the following for the referenced workbook
filename

["HP-"& Range("C5").Value &".xls"]
and left everything else as it was: path before file name and following
worksheet name/cell.

The file name is HP-3.xls. The value in C5 is 3.
 
Back
Top