=INDIRECT("'["&A1&"]"&B1&"'!B2")
file name in A1 and sheet name in B1
--
Regards,
Peo Sjoblom
(No private emails please)
"BorisS" <[email protected]> wrote in message
news:[email protected]...
>I want to have two cells where one tells me the name of a file, and the
>other
> tells me the name of a sheet tab in that file. I would like to be able to
> use those two values in a cell to complete a reference to a cell (let's
> say
> B2 of that file's tab). What is the formatting for this?
>
> Thx.
> --
> Boris
Bookmarks