Need a table, which fills in numbers automatically depending on text in column

Hi Guys and excel Pros :-)

could you help me with my problem?

I want to have a list in Sheet2, lets say:

Column A B
Apple 8
Banana 9
Pear 10

And then I need a table in Sheet1, Where I put the name of fruit in column A and it automatically fills in relevant number (8) to next cell in column B.

So I am looking for forumula to put in Sheet1 in column B.

I was trying with vlookup function, but I can't wrap my head around it.

Can you please help me with this?

Thank you.