Hi,

I am using the array formula below to identify each row in an array that contains the entered string:

{=INDEX(Data!$A1:$I$20,SMALL(IF((Data!$A$1:$I$20=$A$2)*(Data!$A$1:$I$20<>""),ROW(Data!$A$1:$I$20)),ROW(1:1))*1:1)}

I need to display the label for each row identified. The label is contained in cell A of each identified row.

Right now I get an error #REF! instead of a label that should look something like PRODN4APP01.

Where am I going wrong please?