EXCEL HELP

Sheet 1.
Column A contains a list of horses mames
Column B contains each horses rating

Sheet 2.
Column A contains the names of Runners in todays Race

QUESTION.
How can I get program to search Sheet 1 and install appropriate Rating into Column B in Sheet 2.?

Perhaps someone could be kind enough to create a Macro for me please?