Hi all
I need an offset index match to refer to data from another file
I found out that offset doesn t work unless other file is open.
Is there a way around that limitations
this is my formula and i need to offset one column to the right
thank you for your help !!
=IFERROR(INDEX('[20151130 PMIX MASTER.xlsx]YTD'!$A$1:$BAA$999,MATCH($A173,'[20151130 PMIX MASTER.xlsx]YTD'!$A:$A,0),MATCH($A$4,'[20151130 PMIX MASTER.xlsx]YTD'!$5:$5,0)),"")
I need an offset index match to refer to data from another file
I found out that offset doesn t work unless other file is open.
Is there a way around that limitations
this is my formula and i need to offset one column to the right
thank you for your help !!
=IFERROR(INDEX('[20151130 PMIX MASTER.xlsx]YTD'!$A$1:$BAA$999,MATCH($A173,'[20151130 PMIX MASTER.xlsx]YTD'!$A:$A,0),MATCH($A$4,'[20151130 PMIX MASTER.xlsx]YTD'!$5:$5,0)),"")