SOLVED

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

 

laj_16_0-1683683887849.png

  this is the sheet 2

 

laj_16_1-1683683956547.png

 

2 Replies
best response confirmed by laj_16 (Copper Contributor)
Solution

@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_0-1683691682897.png

 

 

it worked thank you
1 best response

Accepted Solutions
best response confirmed by laj_16 (Copper Contributor)
Solution

@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_0-1683691682897.png

 

 

View solution in original post