Concantenate

[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.

 

[Otto Moehrbach]

Chuck
Yes. Within the call of the file name put something like:
& Range("A1").Value &
HTH Otto

 

[Chuck]

Thank you Otto

I must be doing something wrong because I still cannot get it to work.

 

[Chuck]

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.