I have a workbook with 2 worksheets.

Sheet1 has this
sheet1.png


Sheet2 has this
sheet2.png


Desired Result
sheet1_rslt.png



I want to search for B2 in Range sheet2!$B$2:$F$25 and if found copy the contents of column A of the same row in sheet2 to A2 of Sheet1. IF no match found just NA in Column A of Sheet1.

Any Macro that can help is much appreciated.