Hi,
Looking for some help as loosing the will to live with the below formula..
When open the workbook and press UPDATE all results are BLANK. Works only if dont press UPDATE / have external workbooks open OR press enter in the formula cell - results get picked up then.
External workbooks are not tables, have the access to the folders, using office 365.
If anyone would be able to share the knowledge on where I am going wrong would be very much appreciated..
Many thanks,
G.
=IFERROR(IF(AS7="CPU","",
IF(AU7=2022,INDEX('W:\Procurement\Accountability\09. Tracking\01. Commitments\2022\[OMG Commitments Master 2022 - Radio.xlsx]RADIO'!$J$5:$L$5000,MATCH([@[COMMITMENT TAG]],'W:\Procurement\Accountability\09. Tracking\01. Commitments\2022\[OMG Commitments Master 2022 - Radio.xlsx]RADIO'!$C$5:$C$5000,0),1),
IF(AU7=2021,INDEX('W:\Procurement\Accountability\09. Tracking\01. Commitments\2021\[OMG Commitments Master 2021 - Radio.xlsx]RADIO'!$K$5:$O$5000,MATCH([@[COMMITMENT TAG]],'W:\Procurement\Accountability\09. Tracking\01. Commitments\2021\[OMG Commitments Master 2021 - Radio.xlsx]RADIO'!$C$5:$C$5000,0),5),
IF(AU7=2020,INDEX('W:\Procurement\Accountability\09. Tracking\01. Commitments\2020\[OMG Commitments Master 2020 - Radio.xlsx]RADIO'!$K$8:$O$5000,MATCH([@[COMMITMENT TAG]],'W:\Procurement\Accountability\09. Tracking\01. Commitments\2020\[OMG Commitments Master 2020 - Radio.xlsx]RADIO'!$C$4:$C$5000,0),5),0)))),"")
Looking for some help as loosing the will to live with the below formula..
When open the workbook and press UPDATE all results are BLANK. Works only if dont press UPDATE / have external workbooks open OR press enter in the formula cell - results get picked up then.
External workbooks are not tables, have the access to the folders, using office 365.
If anyone would be able to share the knowledge on where I am going wrong would be very much appreciated..
Many thanks,
G.
=IFERROR(IF(AS7="CPU","",
IF(AU7=2022,INDEX('W:\Procurement\Accountability\09. Tracking\01. Commitments\2022\[OMG Commitments Master 2022 - Radio.xlsx]RADIO'!$J$5:$L$5000,MATCH([@[COMMITMENT TAG]],'W:\Procurement\Accountability\09. Tracking\01. Commitments\2022\[OMG Commitments Master 2022 - Radio.xlsx]RADIO'!$C$5:$C$5000,0),1),
IF(AU7=2021,INDEX('W:\Procurement\Accountability\09. Tracking\01. Commitments\2021\[OMG Commitments Master 2021 - Radio.xlsx]RADIO'!$K$5:$O$5000,MATCH([@[COMMITMENT TAG]],'W:\Procurement\Accountability\09. Tracking\01. Commitments\2021\[OMG Commitments Master 2021 - Radio.xlsx]RADIO'!$C$5:$C$5000,0),5),
IF(AU7=2020,INDEX('W:\Procurement\Accountability\09. Tracking\01. Commitments\2020\[OMG Commitments Master 2020 - Radio.xlsx]RADIO'!$K$8:$O$5000,MATCH([@[COMMITMENT TAG]],'W:\Procurement\Accountability\09. Tracking\01. Commitments\2020\[OMG Commitments Master 2020 - Radio.xlsx]RADIO'!$C$4:$C$5000,0),5),0)))),"")