Formula to match a cell with value in a column and return a specific value

Hi, I'm new this this forum and a beginner excel user too. So apologize if I post something wrong or if my question below is a bit difficult to understand.

I have two worksheet. Basically Worksheet 1 which is all the data and Worksheet 2 is the fill in sheet.
This is what the worksheet looks like
sheet1.png

sheet2.png and this is the result I want to have ---> sheet2_result.png

In other words,
If cell B2 in sheet2 equals with any value of Column B:B sheet1, then display the corresponding name from data in sheet1 in cell A2 sheet2.
I want the Name and Item in sheet 1 corresponds to each other / linked. So when I change any value in Worksheet 1, the value in Worksheet 2 also change.

I will be really grateful for some advise on this. Thank you so much.

Formula:

=IFERROR(INDEX(Sheet1!$A$2:$A$20,MATCH(Sheet2!$B2,Sheet1!$B$2:$B$20,0)),"")

In A2 of sheet 2

Punnam

Thank you so much for both of your help boopathiraja and Punnam, both works like magic =D
But I notice difference in the formula, why do we need to put 'IFERROR' in the beginning?
Will this matter if the cell value is a number instead of text?
Once again, I'm really grateful for all your help!
Have a great day to you all

Hi code_excel ,

Thanks for the feedback & Reps(:-), if that cares your question mark the thread solved using thread tools .

Punnam