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.
Bookmarks