Lookup Stores and mark with X

[IvanYerk]

I need to put an 'X' under the appropriate month based on the data list.

 

[alansidman]

If the number 1 will work for you then you can do this with a Pivot Table

Book1
	A	B	C	D	E	F
2
3	Count of Store	Months	Date
4		Jan	Mar	Apr	May	Jun
5	Store
6	Store A	1		1		1
7	Store B				1
8	Store C		1			1
Sheet2

 

[Fluff]

If your dates will only be for one year how about

Book1
	A	B	C	D	E	F	G
2	Store A	05/01/2019
3	Store B	08/05/2019
4	Store C	19/03/2019
5	Store A	20/04/2019
6	Store A	02/06/2019
7	Store C	30/06/2019
8
9
10		01/01/2019	01/02/2019	01/03/2019	01/04/2019	01/05/2019	01/06/2019
11	Store A	X			X		X
12	Store B					X
13	Store C			X			X
Sheet1

Cell Formulas
Range	Formula
B11:G13	B11	=IF(ISNUMBER(MATCH($A11&"|"&MONTH(B$10),INDEX($A$2:$A$7&"|"&MONTH($B$2:$B$7),0),0)),"X","")

 

[IvanYerk]

Thank you both! I think it's so awesome that people are so willing to help on here. Life savers!

 

[Fluff]

Glad we could help & thanks for the feedback