vLookup or other formula? entire row search with a Yes or No answer

[dedersm]

I have a chart like the one below. My end result should be able to answer the question, "Does Store 1 get graphic D?" Yes. Or, "Does Store 4 get graphic B?" No.

Is their a formula that I can use do get there?

Thanks for your help!

Store #	Location 1	Location 2	Location 3	Location 4	Location 5
1	Graphic A	Graphic B	N	Graphic C	Graphic D
2	Graphic C	Graphic D	N	N	N
3	Graphic A	Graphic C	Graphic D	N	Graphic B
4	N	N	N	Graphic A	Graphic C
5	Graphic E	Graphic F	Graphic G	N	Graphic H
6	Graphic H	N	Graphic G	N	Graphic F
7	Graphic A	Graphic F	Graphic G	Graphic B	N
8	Graphic H	N	N	N	N
9	Graphic B	N	N	Graphic H	N

<tbody>
</tbody>

 

[AhoyNC]

Try:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Store #	Location 1	Location 2	Location 3	Location 4	Location 5		Store #	Graphic
2	1	Graphic A	Graphic B	N	Graphic C	Graphic D		3	Graphic D	Yes
3	2	Graphic C	Graphic D	N	N	N
4	3	Graphic A	Graphic C	Graphic D	N	Graphic B
5	4	N	N	N	Graphic A	Graphic C
6	5	Graphic E	Graphic F	Graphic G	N	Graphic H
7	6	Graphic H	N	Graphic G	N	Graphic F
8	7	Graphic A	Graphic F	Graphic G	Graphic B	N
9	8	Graphic H	N	N	N	N
10	9	Graphic B	N	N	Graphic H	N
Sheet