I am not really sure what you want, or how you arrive at the "correct result".
Can you walk me though what you are trying to do (and remember, we have no clue what you are working with, or what you want).
As an alternative, I used this ARRAY formula, copied down...
=INDEX(الرمز,MATCH(E2&F2&B2&C2,$E$2:$E$58&$F$2:$F$58&$B$2:$B$58&$C$2:$C$58,0))
This obviously pulls in all matches, and can be converted to a regular formula using a helper...
=E2&F2&B2&C2
and then change that to this regular formula...
=INDEX(الرمز,MATCH(E2&F2&B2&C2,$Q$2:$Q$58,0))
Bookmarks