Forum Discussion

laj_16's avatar
laj_16
Copper Contributor
May 10, 2023
Solved

tranferring data with the same id from different sheet

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

 

 

excel
Excel for web
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    May 10, 2023

    laj_16 Simple VLOOKUP() should work.

    =VLOOKUP(A2,Sheet2!$A$1:$D$5,4,FALSE)

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

    =XLOOKUP(A2:A5,Sheet2!A2:A5,Sheet2!D2:D5)

     

     

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    May 10, 2023

    laj_16 Simple VLOOKUP() should work.

    =VLOOKUP(A2,Sheet2!$A$1:$D$5,4,FALSE)

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

    =XLOOKUP(A2:A5,Sheet2!A2:A5,Sheet2!D2:D5)

     

     

Resources