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?
Bookmarks