INDEX MATCH

[j4ymf]

Hello All

please could you help me change this formula

=IFNA(INDEX(Download!$J$2:$J$9999,MATCH(B67&"|"&A67,INDEX(Download!$F$2:$F$9999&"|"&Download!$Q$2:$Q$9999,0),0)),"")

A67 = £0.00

how do i change it to look for a blank cell as well

ho do i replace the &A67 with {"£0.00",0,""}

Thank you Jason

 

[jasonb75]

Maybe something like

=IFERROR(INDEX(Download!$J$2:$J$9999,AGGREGATE(15,6,ROW(Download!$J$2:$J$9999)/(Download!$F$2:$F$9999=B67)/((Download!$Q$2:$Q$9999=A67)+(Download!$Q$2:$Q$9999="")),1)),"")

Note that this uses different methods to your old formula, it may well work without the last array, i.e.

=IFERROR(INDEX(Download!$J$2:$J$9999,AGGREGATE(15,6,ROW(Download!$J$2:$J$9999)/(Download!$F$2:$F$9999=B67)/(Download!$Q$2:$Q$9999=A67),1)),"")