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