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 ...

excel

Excel for web

Formulas and Functions

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

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)

laj_16

Copper Contributor

May 10, 2023

it worked thank you

Forum Discussion

tranferring data with the same id from different sheet

Resources