merging two sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1888668%22%20slang%3D%22en-US%22%3Emerging%20two%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1888668%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHi.%20%3C%2FSPAN%3E%3CSPAN%3EI%20%26nbsp%3Bhave%20two%20spreadsheets.%20Both%20sheets%20have%20the%20%26nbsp%3Bsame%20unique%20identifier%20(an%20EAN)%20against%20each%20record%20but%20all%20the%20rest%20%26nbsp%3Bof%20the%20headers%20are%20different.%20This%20EAN%20is%20A2%20on%20both%20sheets.%20Sheet1%3AA2%20%2C%20Sheet2%3AA2%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ESheet%202%20has%20values%20in%20cell%20B2%20that%20I%20want%20to%20%E2%80%9Cimport%E2%80%9D%20%26nbsp%3Bto%20Sheet%201.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EWhat%20I%20need%20is%3A%20If%20A2%20in%20Sheet%201%20equals%20A2%20in%20Sheet%202%2C%20it%20adds%20B2%20in%20Sheet%202%20to%20B2%20in%20Sheet%201%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EApologies%20if%20not%20clear....I%E2%80%99m%20not%20an%20excel%20whizz%20!%20%26nbsp%3BAny%20help%20greatly%20appreciated%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1888668%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1888688%22%20slang%3D%22en-US%22%3ERe%3A%20merging%20two%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1888688%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869638%22%20target%3D%22_blank%22%3E%40anglomex%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20B2%20on%20Sheet%201%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DVLOOKUP(A2%2C%20'Sheet%202'!%24A%242%3A%24Z%241000%2C%202%2C%20FALSE)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

 

Hi. I  have two spreadsheets. Both sheets have the  same unique identifier (an EAN) against each record but all the rest  of the headers are different. This EAN is A2 on both sheets. Sheet1:A2 , Sheet2:A2
Sheet 2 has values in cell B2 that I want to “import”  to Sheet 1.

What I need is: If A2 in Sheet 1 equals A2 in Sheet 2, it adds B2 in Sheet 2 to B2 in Sheet 1

Apologies if not clear....I’m not an excel whizz !  Any help greatly appreciated

2 Replies
Highlighted

@anglomex 

In B2 on Sheet 1:

 

=VLOOKUP(A2, 'Sheet 2'!$A$2:$Z$1000, 2, FALSE)

 

Fill down.

Highlighted
Thanks Hans. I'm not getting this to work but this might be because I don't quite understand it. However, I've asked my son to explain it to me slowly and in simple words !
I really appreciate your response.