The best solution is born from knowing how to do it in Excel itself first.
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.