Indirect function to another workbook and autofill other cells

Help please! Needing to make this formula autofill and having a lot of troubles. It is pulling data from another open workbook.

=INDIRECT("'[Touchbase Report_CC.xlsx]"&$A$1&"'!X89")

A1 is where my sheet name is housed to lookup
X89 is the cell I want it to find and the cell below to be X90


Also, is there a way to get this to add values in another workbook, for instance, if I want it to add X89 with X110 is that possible in an indirect?

Try it like this:

=INDIRECT("'[Touchbase Report_CC.xlsx]"&$A$1&"'!X"&ROW(A89))

then copy down.

For your second part you could do this:

=INDIRECT("'[Touchbase Report_CC.xlsx]"&$A$1&"'!X89") + =INDIRECT("'[Touchbase Report_CC.xlsx]"&$A$1&"'!X110")

Hope this helps.

Pete

Thank you! That worked!

Glad to help, Sarah, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete