I have two columns : one with names in Arabic and the other with names in English which are sorted alphabetically
I used ( look up ) formula but it returns wrong results
=LOOKUP(G$1:G$100;$A$1:$A$100;$B$1:$B$100)
<tbody>
<colgroup><col width="72" style="width:54pt"> </colgroup><tbody>
احمد...