Would like information to create a formula for the following senario.

In sheet 1 column A have a list of names.

In sheet 2 column A have a list of names and column c a list of numbers.

want to search sheet 1 column a with names from sheet 2 column a and if
found post the corresponding number from sheet 2 column c.

Any help appreciated
--
George