Search and replace by mask?

Question

excel

Conventionally, there are three columns, a,b,c in the first are mixed names, in the second a unique id, in the third the value corresponding to this id.

All values ​​"Vasya" must be assigned "1", "Petya" "2", "Lesha" "3", etc.
in short, assign the corresponding id from column b to all values

Answer 1

here

Answer 2

VLOOKUP

Answer 3

Value substitution and a host of other useful things can be done using the VLOOKUP function .