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
"Chuck" <(E-Mail Removed)> wrote in message
news:u%(E-Mail Removed)...
> 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.
>
>

Thank you Otto

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

"Otto Moehrbach" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Chuck
> Yes. Within the call of the file name put something like:
> & Range("A1").Value &
> HTH Otto
> "Chuck" <(E-Mail Removed)> wrote in message
> news:u%(E-Mail Removed)...
> > 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.
> >
> >
>
>

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.




"Otto Moehrbach" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Chuck
> Yes. Within the call of the file name put something like:
> & Range("A1").Value &
> HTH Otto
> "Chuck" <(E-Mail Removed)> wrote in message
> news:u%(E-Mail Removed)...
> > 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.
> >
> >
>
>