Find or search a sheet and input value

I have sheet 1 with two columns. Column A has a name and B column has a number value. In total there are 443 rows.

On sheet two I have another list of names in 1 column about 52 rows long.

On sheet 2 I would like a formula that finds the name on sheet 2 in column A sheet 1 and transfers the corresponding numerical value found in column B sheet 1 to sheet 2.

Thank you

It’s trivial, it can be

=VLOOKUP(A2;$Sheet1.A:B;2;0)

if names in first sheet is unique or

=SUMIF($Sheet1.A:A;A2;$Sheet1.B:B)

in other case