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
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)),"")