Index Match

[j4ymf]

Hello

I have this formula which someone on this forum has written for me but i need to change it to match the second option in the list.
Thank you

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

 

[Peter_SSs]

Since you have Excel 365 I have assumed that you have the FILTER function, so try

=IFERROR(INDEX(FILTER(Download!J2:J9999,(Download!F2:F9999=B42)*(Download!Q2:Q9999=A42)),2),"")

If you happen to not have FILTER() then try

=IFERROR(INDEX(Download!J:J,AGGREGATE(15,6,ROW(Download!J2:J9999)/((Download!F2:F9999=B42)*(Download!Q2:Q9999=A42)),2)),"")