First, please see the attached file. It is comprised of the following tabs:
1) Sheet 1
5) Master Vocab
Tab #5, Master Vocab tab includes a list of around 2,000 words in English, Russian and Turkish.
Tab #1, Sheet 1, has a shorter list of a little more than 600 words, only in English.
Your first tab is to look at the Master Vocab tab and populate the Russian and Kabardian columns in Sheet 1. You must keep the word order (first column) in the Sheet 1 tab.
Once this is done, all of the words in columns C, D and E (Russian, Turkish and Kabardian) will be populated and appear to the right of their English translations.
That is Part 1.
In Part 2, once Sheet 1 is fully populated, I then need you to populate the frequency ranking of each word in each language.
So for example, in Sheet 1, the first word is "long". In the ENG_Freq sheet, "long" has a frequency ranking of 255. So in Sheet 1, keeping "long" where it is, in column H, called ENG_Rank, the value would be 255.
In contrast, the Russian translation (which I have already populated manually) has a ranking of 400, and the Turkish translation has a ranking of 195. (There is no Kabardian frequency table to lookup.)
I am sure that there is an easy way to do this in Excel that wouldn't take very long, but I don't know how to do it.
I need you to accomplish this task and then return the list for me.