You want to find the "Word AR" Sheet1 column G in "Word AR" Sheet2 column B, in other word find the arabic word for the English word from another table.

Paste this formula in Sheet1 cell G2, and drag it down.

=IF(F2="",,INDEX(Sheet2!$B$2:$B,IFNA(MATCH(F2,Sheet2!$A$2:$A,0),"No Match")))

Breakdown:

1 - MATCH function to find the matching row in the range Sheet2!$A$2:$A with [search_type] set to 0 to finds the exact value when range is unsorted.

2 - INDEX gives back a cell's content when given a row and column, our reference is Sheet2!$B$2:$B we set the [column] as 1 or left it blank in case of a single column and pass the result of MATCH function as [row].

3 - handel N/A error with IFNA function and set [value_if_na_error] to "No Match".

4 - IF function IF(F2="",,[value_if_false] To calculate only when the cells of F columns are not blank.

hope that answers your question.

You want to find the "Word AR" Sheet1 column G in "Word AR" Sheet2 column B, in other word find the arabic word for the English word from another table.

Paste this formula in Sheet1 cell G2, and drag it down.

=IF(F2="",,INDEX(Sheet2!$B$2:$B,IFNA(MATCH(F2,Sheet2!$A$2:$A,0),"No Match")))

Breakdown:

1 - MATCH function to find the matching row in the range Sheet2!$A$2:$A with [search_type] set to 0 to finds the exact value when range is unsorted.

2 - INDEX gives back a cell's content from a range when given a row and column, our reference is Sheet2!$B$2:$B we set the [column] as 1 or left it blank in case of a single column and pass the result of MATCH function as [row].

3 - handel N/A error with IFNA function and set [value_if_na_error] to "No Match".

4 - IF function IF(F2="",,[value_if_false] To calculate only when the cells of F columns are not blank.

hope that answers your question.