خرید بک لینک

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.

برچسب: نویسنده: استخدام کار تاريخ: چهارشنبه 8 ارديبهشت 1395 ساعت: 22:03

صفحه بندی