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.

Please Login or Register  to view this content.

Originally Posted by AliGW

Try this:

=INDEX(Sheet2!$B$2:$B$8,MATCH(A2,Sheet2!$A$2:$A$8,0))

*******************
Thanks for posting the formula.
Actually, My requirement is:
- Need to fetch the "SUPERVISOR NAME" record in Sheet 1(marked as colour code in last col. of sheet1), by looking Sheet 2 table, and mapping the primary key of Prod ID in sheet 1 and same Prod ID of Sheet 2, preferably using VLookup,
- Final result would be, I can get all Supervisor names, in sheet 1, which are mapped the Prod. Id of Sheet 2.

The above reply didn't give me any result.

Thanks
Somu

Maybe you did something wrong because the formula Ali gave seems correct to me. So is the VLOOKUP example given. Thirdly, since you are on O365, you have the new formula you can use which is XLOOKUP. This would go in cell G2 of Sheet1
=XLOOKUP(A2,Sheet2!$A$2:$A$8,Sheet2!$B$2:$B$8,"Not found",0)
In fact, you could use the Array by bringing back all the answers with:
=XLOOKUP(A2:A27,Sheet2!$A$2:$A$8,Sheet2!$B$2:$B$8,"Not found",0)