Using VLookup, to find the similar element in another sheet and update in first sheet

HI Guys,

I have one excel with two sheet. In Sheet1, I have the information like Prod ID, Master UNit, Sub Unit, Time Logged, Work logged, Time difference and SUPERVISOR NAME(which I need to find out from sheet 2). Sheet 2 consists of Prod ID, Supervisor name, Manager Name and Unit Hed.

Requirement:
Need to find the SUPERVISOR NAME in sheet1, which is mapped in Sheet 2 with same Prod ID. The result supervisor name need to be updated in Sheet 1 "SUPERVISOR TAB" by using VLookup.
Please share the VLookup formula.