Cross checking two email worksheets

[PhilDesanex]

As part of a company takeover, we have two excel worksheets. One (Sheet A) is a list of customers (name address email phone postcode etc) who have bought from the website at some time. The other (Sheet B) is a list of just email addresses that, at some point, registered to receive newsletters from the site (they may or may not have bought). I want to check the list of email addresses in Sheet B against those in sheet A. If the email address in B exists in A, do nothing. If it doesn't exist, either set a flag in a column (so I can sort later and copy manually) or copy the email address to the foot of sheet A. I can make the sheets have the same cell structure.

 

[Toadstool]

Hi PhilDesanex,

Here's my SHEETA

PhilDesanex.xlsx
	A	B	C	D
1	Name	Company	Email	Phone
2	Susan Smith	ACME Widgets	Susan@ACME.com	(231) 231-2312
3	Alf Carruthers	Bridges Stuff	Alf@Bridges.com	(251) 251-2512
4	Sarah Pollard	ACME Widgets	Sarah@ACME.com	(261) 261-2612
5	Zoe Green	Carter PLC	Zoe@Carter.com	(271) 271-2712
6	Vanessa Attwood	Dry & Co.	Vanessa@Dry.com	(281) 281-2812
7	Lily Smithers	Bridgeforth	Lily@Bridgeforth.com	(282) 311-3113
8	Hannah Ross	Easy Partners	Hannah@Easy.com	(291) 291-2912
9	John Connelly	Green & Son	John@Green.com	(301) 301-3013
10	Lily Smithers	Hope & Sky Inc.	Lily@Hope.com	(311) 311-7299
11
SHEETA

Here's the SHEETB list of email addresses with those flagged as missing from SHEETA

PhilDesanex.xlsx
	A	B
1	Email	Not on SHEETA?
2	Susan@ACME.com
3	Bert@Altwood.com	Yes
4	Alf@Bridges.com
5	John@Lily.com	Yes
6	John@Mint.com	Yes
7	Charlie@White.com	Yes
8	Nigel@Whites.com	Yes
9	Zoe@Carter.com
10
SHEETB

Cell Formulas
Range	Formula
B2:B10	B2	=IF(A2="","",IF(ISNA(MATCH(A2,SHEETA!C:C,0)),"Yes",""))