Hi All,
I'm trying to use the INDIRECT function within the following but it just doesnt seem to work: =IFERROR(INDEX(INDRECT(Sheet1!$A:$G), MATCH(1, (INDIRECT(Sheet1!A:A=$A$1))*((INDIRECT(Sheet1!C:C=D3)),0),5),0)
Any assistance please as I need to ensure the reference starys active even when data is deleted from the sheet.
Cheers!
I'm trying to use the INDIRECT function within the following but it just doesnt seem to work: =IFERROR(INDEX(INDRECT(Sheet1!$A:$G), MATCH(1, (INDIRECT(Sheet1!A:A=$A$1))*((INDIRECT(Sheet1!C:C=D3)),0),5),0)
Any assistance please as I need to ensure the reference starys active even when data is deleted from the sheet.
Cheers!