Hi All,
Looking for help to convert this formula to use a dynamic sheet reference in cell B1. I tried it myself but always broke the logical statement in the process.
Here is the working formula (without the dynamic sheet reference)
=INDEX('[agent_raw.xlsx]2.14'!$B:$B,MATCH(MAX(IF('[agent_raw.xlsx]2.14'!$A:$A="MTVSSL",'[agent_raw.xlsx]2.14'!$Z:$Z)),IF('[agent_raw.xlsx]2.14'!$A:$A="MTVSSL",'[agent_raw.xlsx]2.14'!$Z:$Z),0))
Thanks for your support
Looking for help to convert this formula to use a dynamic sheet reference in cell B1. I tried it myself but always broke the logical statement in the process.
Here is the working formula (without the dynamic sheet reference)
=INDEX('[agent_raw.xlsx]2.14'!$B:$B,MATCH(MAX(IF('[agent_raw.xlsx]2.14'!$A:$A="MTVSSL",'[agent_raw.xlsx]2.14'!$Z:$Z)),IF('[agent_raw.xlsx]2.14'!$A:$A="MTVSSL",'[agent_raw.xlsx]2.14'!$Z:$Z),0))
- I have a Combobox with a list of Months. If for example January is selected, cell B1 will contain the dynamic reference 1.14
- 1.14 stands for January 2014
- My sheets are labelled as 1.14 etc
- I need to include a dynamic reference in the formula to change only the sheet name (The workbook names is fixed)
Thanks for your support