How to match two columns in Excel so that the same columns are opposite each other?

Question

excel

For example, there is a column
Ivan Ivanov
Vasya Pupkin
Petya Popov
Masha Dmitrieva
And there is a second (and next to it the second column with a numerical value):
Nikolai Koster Valdau - 2
Petr Dimitrov - 9
Ivan Ivanov - 12
Vasya Pupkin - 15
Here's how to compare these two columns in order to opposite "Ivan Ivanov - Ivan Ivanov" and so on to copy the numeric values ​​to the first column?
The second column has data, numeric (this is the next column), and you need to copy the data of these values ​​\u200b\u200bto the first column opposite each name

Answer 1

See what exactly you need.
Look towards VLOOKUP or SUMIF / SUMIFS