Look up a word, then input a word from cell adjacent [Closed]

Im looking for a way; in excel, to search for a word, find the word then take a value from the cell directly adjacent to that cell. For example:
Sheet 1
Bananas | ?
Apples | ?

Sheet 2:
Apples | 34
Bananas | 56

Basically i want a formula for Sheet 1, column B to search Sheet 2 column A, find the relevant word ie 'Apples' but then take the value from column B

I feel like it is something excel can do and if possible the formula could also take a percentage of the desired field
I Hope someone can help

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!