Compare one cells from sheet 2 and paste the value in front of the cell

Hello,
I m new to excel with VB coding
Please help me
I have the table as follows:-

Shee1 1
A B
1 apple 10
2 mango 100
3 banana 1000


now if i go to sheet 2 and type in

A1 "Banana" then automatically there would be "1000" in cell B1

sheet 2
A B
1 Banana 1000
2 apple 10
3


suggest me any formula in vba

thanks

thanks for your reply

Plz see the attatchment

Hello Mr. Robert

I have tried again and my problem is solved now.

thanks,

Ms. Jeevan

Hello Trebor76

I have tried again and my problem is solved now.

thanks,

Ms. Jeevan