Forum Discussion

Copper Contributor

Nov 15, 2020

merging two sheets

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

excel

HansVogelaar

MVP

Nov 15, 2020

anglomex

In B2 on Sheet 1:

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

Fill down.

anglomex

Copper Contributor

Nov 16, 2020

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.