Use of Indirect

[march]

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!

 

[Skybluekid]

I think you are using the function incorrectly. INDIRECT takes a Text input and uses that to reference a cell or range within the workbook.

Have a look at this INDIRECT function - Microsoft Support