Can't seem to get the correct formula for a lookup

[DarExcel]

I want to link up some data from a reference cell (AAA, BBB, etc) and pull that into a matrix with all possible values in columns... This is sort of what I am looking for. I can't figure out how to do an index match or a lookup to get it to work. Thanks!

AAA	BBB	CCC			Response 1	Response 2	Response 3	Response 4	Response 5	Response 6	Response 7
Response 1	Response 3	Response 6		AAA	x	x	x			x	x
Response 2	Response 5	Response 7		BBB			x		x		x
Response 3	Response 7	Response 8		CCC						x	x
Response 6	Response 9	Response 9
Response 7	Response 11	Response 10
Response 8	Response 13	Response 11
Response 9	Response 15	Response 12
Response 12	Response 17	Response 13
Response 13	Response 19	Response 14
Response 14		Response 15
		Response 16
		Response 17

<tbody>
</tbody>

 

[DarExcel]

bump...thanks!

 

[63falcondude]

How's this?

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L
1	AAA	BBB	CCC			Response 1	Response 2	Response 3	Response 4	Response 5	Response 6	Response 7
2	Response 1	Response 3	Response 6		AAA	x	x	x			x	x
3	Response 2	Response 5	Response 7		BBB			x		x		x
4	Response 3	Response 7	Response 8		CCC						x	x
5	Response 6	Response 9	Response 9
6	Response 7	Response 11	Response 10
7	Response 8	Response 13	Response 11
8	Response 9	Response 15	Response 12
9	Response 12	Response 17	Response 13
10	Response 13	Response 19	Response 14
11	Response 14		Response 15
12			Response 16
13			Response 17
Sheet3

Cell Formulas
Range	Formula
F2	=IF(SUMPRODUCT(($A$1:$C$1=$E2)*($A$2:$C$13=F$1)),"x","")

 

[DarExcel]

Thank works! I'll figure out why later. Thanks so much

 

[63falcondude]

Thank works! I'll figure out why later. Thanks so much

Glad to help!

 

[JimboP77]

something like =IFERROR(IF(VLOOKUP(F$1,$A$2:$A$13,1,FALSE)="#N/A","","x"),"") might work...