I am attempting to have the worksheet of an exteal workbook update to a reference cell on a current work book.
This is my code so far.
=INDEX([Test.xlsx]indirect("I8")!$A$3:$B$7, MATCH(I8,[Test.xlsx]indirect("i8")!$A$3:$A$7,0),2)
Where Test is the exteal book and I8 is on the current book and sheet.
Any help with this would be greatly appreciated.
برچسب:
نویسنده: استخدام کار