tranferring data with the same id from different sheet

Copper Contributor

Good day I want to ask help with this problem.


I have 2 sheets. The first one is where the original record is, while the sheet 2 is where the updating happen. What I want is whatever being input in the sheet2 column update is going to appear too in the update column in sheet 1 as long as they have the same ID.


this is the sheet 1



  this is the sheet 2




2 Replies
best response confirmed by laj_16 (Copper Contributor)

@laj_16 Simple VLOOKUP() should work.


If you are on Microsoft-365 then could try XLOOKUP()





it worked thank you