Using Vlookup or similar function to find missing values compared to base values

Hello, I am trying to find some missing values compared to 6 base values. For instance, I have a sheet with some names translated to another language, I am trying to find the languages some names have not been translated too.

For example, if I have six languages, Arabic, Japanese, Russian, Chinese-Simplified, Chinese- Traditional, and Korean to compare too, I want to find any names that are not translated in certain languages.

Sample:

John Japanese
John Chinese - Simplified
John Korean
Martin Arabic
Martin Chinese - Simplified
Martin Russian
Ramon Arabic
Ramon Russian
Sam Arabic
Sam Chinese- Traditional

Thanks in advance!

Maybe =COUNTIFS(ColumnA,Name,ColumnB,Language) If it's 0 it's not yet been translated, if it's greater than 1 then it's on your list more than once. (Assumes names are in column A and language translated to is in column B).