Match Columns across sheet and Return adjacent cell value

Respected forum members

Seeking your help for formula. I have two sheet, i want to match values of Col A in Sheet1 with Col A of Sheet2 and return the value of Col B adjacent column of Sheet 1 in Column E of Sheet 2 when there is match on Data of Col A's across sheets. Kindly help

Thank youMatch and return.xlsx

Thank you. I realized the issue, i was using sheet on sharepoint and it had links to other sheets, that is why when i tried Vlookups it was not working and upon seeing ur solution working and trying in dummy sheet, i realized it.. Thanks much Bosco_yip