The best solution is born from knowing how to do it in Excel itself first.
Vlookup
or
Match
are excel specific functions that make this easy for you. Here is an article on this topic:
Look up values with VLOOKUP, INDEX, or MATCH[
^]
Note: this is the google search used to find this article:
excel find a row in a column - Google Search[
^]
There are many other links that discuss this in detail.
Once you understand how, via researching the topic, then you are armed with the knowledge to develop a solution.