Looking for formula help that may be complicated

[allsmilees2]

I would like to have my excel sheet look up names from one column based on two things:
1. that the column header matches the drop down menu
2. that the answer matches the drop down selected answer.

any help would be great. basically I want names from A1, that answered the question from "what Topic" that corresponds with a column header with the answer that is picked from the drop down menu.

athanks

 

[StephenCrump]

Welcome to the Forum!

Perhaps something like this?

	A	B	C	D	E	F	G	H
1			Vendor			Q1	Q2	Q3
2	Look for		A			Blah	Blah	Blah
3	Q2		B			Blah	Blah	Blah
4	Yes		C			Blah	Yes	Blah
5			D			Blah	Blah	Blah
6	List:		E			Blah	Blah	Blah
7	C		F			Blah	Blah	Blah
8	H		G			Blah	Blah	Blah
9	K		H			Blah	Yes	Blah
10			I			Blah	Blah	Blah
11			J			Blah	Blah	Blah
12			K			Blah	Yes	Blah
13			L			Blah	Blah	Blah
Sheet3

Cell Formulas
Range	Formula
A7:A9	A7	=FILTER(INDEX(MyData,,1),INDEX(MyData,,MATCH(Question,INDEX(MyData,1,),))=Response)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
MyData	=Sheet3!$C$1:$H$13	A7
Question	=Sheet3!$A$3	A7
Response	=Sheet3!$A$4	A7