Is there a function in Google Sheets to return the string next to a string that I match from a colum-CodePudding

Okay, Sheet1!F:F is a list of words in English. The same word occurs multiple times and the sheet is organized in order of chapters with the words in question in order as they appear in the chapter. "G:G needs to be that word in Arabic. "H:H needs to be the definition in English. "I:I needs to be the definition in Arabic.

Sheet2!A:A has the word in English, B:B the word in Arabic, C:C the definition in English, D:D the definition in Arabic.

Is there a function that would allow me to find the word from Sheet1!F:F in Sheet2!A:A and return Sheet2!B:B in Sheet1!G:G?

Here's some snipits of an example sheet.

hope that answers your question.

CodePudding user response：

One option would be to use a VLOOKUP formula. For example:

=ifna(arrayformula(vlookup(A2:A, Sheet2!A2:D, 2,0)))

Sheet1:

Sheet2:

This formula can be adjusted to fit your needs:

=ifna(arrayformula(vlookup(F3:F, Sheet2!A2:D, 2,0)))
This can be placed in cell G3 of your Sheet1 and it will auto fill down the column. Repeat this for the next 3 columns, and simply increment from 2 in the original (ie =ifna(arrayformula(vlookup(F3:F, Sheet2!A2:D, 3,0))), etc)