I've tried indirect before, but I must be missing something.

Remember that I am trying to insert this WITHIN the path to the file. Here
is my actual formula -

='\\Forms\Pending\address\[address.xlsx]importexport'!G$2)

I want it to replace the word "address" in two spots above with the contents
of cell A7. Can you give me the syntax of exactly how to type it within that
formula? I tried putting in indirect as follows, but it didn't work.

='\\Forms\Pending\=indirect("Sheet1"&a7)\[=indirect("Sheet1"&a7).xlsx]importexport'!g$2)


"Sheeloo" wrote:

Try INDIRECT...

essentially build a string using a formula which gives you the address of
the cell you are pulling the value from and wrap INDIRECT around

eg
=Sheet1!A1
can be replaced by
=INDIRECT("Sheet1!A" & B1)
where B1 contains 1

when B1 changes to 2
your formula will work as
=Sheet1!A2

"bsharp" wrote:

I have a summary workbook that pulls information in from other workbooks.
Each workbook relates to one specific real estate property. So each of the
source workbooks is exactly the same, except for the values within the cells
within the workbook, but the format and headings are identical.

So in my summary document, I have the property addresses down the far left
column, then I put links to the specific cell within the source document
across the row. For example: \\computer\my files\123 main st\[123 main
st.xlsx]termsA1

It looks like this -

PROPERTY PRICE CLOSE DATE BUYER NAME
123 main st $200000 5/1/09 Smith
456 maple $100000 5/15/09 Jones


What I would like to do is just type in the property address into the left
column to start a new row, and the links will use that address to insert into
the path. So in my path example above, I would like to insert a cell
reference instead of the words "123 main st"

I'm using find and replace now, but was hoping for a more elegant solution.