Nov 15 2020 11:30 AM
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
Nov 15 2020 11:35 AM
Nov 16 2020 02:14 AM