I need to return multiple VALUES, i.e., return list of delivery nos(in cell C2 in sheet Formula) from the sheet upload data against a criteria that these deliveries are tractor(column J from sheet Upload Data) and priority 1 (column I from sheet Upload Data)
I have used the formula below: But this doesn't work
=INDEX('Upload Data'!$A$2:$J$166,SMALL(IF('Upload Data'!$J$2:$J$166&DATA9=Formula!$D$3&Formula!$D$4,ROW('Upload Data'!$I$2:$J$166)),ROW(1:1)),1)

Please help.