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