Hi everyone,
Written below is my formula and yellow text in it is a sheet name in a workbook named as "3 - P&L BP monthly". In this work book I have multiple sheets from where data is extracted. All I want is to make the yellow text dynamic and give its reference to a specific cell let say A1. If value in A1 is changed then the formula should go to that sheet of the same work book and extract what is required.
=INDEX('[3 - P&L BP monthly.xlsx]Central (ISD & SISD)'!$D$3:$AA$18,MATCH($A41,'[3 - P&L BP monthly.xlsx]Central (ISD & SISD)'!$A$3:$A$18,0),MATCH(D$2,'[3 - P&L BP monthly.xlsx]Central (ISD & SISD)'!$D$2:$AA$2,0))
Thanks in advance for your help.
Imran,
Written below is my formula and yellow text in it is a sheet name in a workbook named as "3 - P&L BP monthly". In this work book I have multiple sheets from where data is extracted. All I want is to make the yellow text dynamic and give its reference to a specific cell let say A1. If value in A1 is changed then the formula should go to that sheet of the same work book and extract what is required.
=INDEX('[3 - P&L BP monthly.xlsx]Central (ISD & SISD)'!$D$3:$AA$18,MATCH($A41,'[3 - P&L BP monthly.xlsx]Central (ISD & SISD)'!$A$3:$A$18,0),MATCH(D$2,'[3 - P&L BP monthly.xlsx]Central (ISD & SISD)'!$D$2:$AA$2,0))
Thanks in advance for your help.
Imran,