Return a list based on specific values

[Graham C1600]

Hi All,
I'm wanting a function to look down a list and based on certain required criteria on that lookup, return all values in a list format starting in a specified cell. So as below let's call this range A1:D5.
I want the lookup to look down Column A:A searching for "Graham" and then in C1 populate a list based on the lookup but include the values from column B:B. So Columns C and D would be blank until the lookup is run.

Hope this makes sense.

Thanks

Graham	Taylor	Graham	Taylor
Simon	Smith	Graham	Smith
Bruce	Turner	Graham	Bunce
Graham	Smith
Graham	Bunce

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1			Graham
2	Graham	Taylor	Graham	Taylor
3	Simon	Smith	Graham	Smith
4	Bruce	Turner	Graham	Bunce
5	Graham	Smith
6	Graham	Bunce
7
8
9
Main

Cell Formulas
Range	Formula
C2:D4	C2	=FILTER(A2:B10,A2:A10=C1)
Dynamic array formulas.

 

[Graham C1600]

How about

+Fluff 1.xlsm
	A	B	C	D
1			Graham
2	Graham	Taylor	Graham	Taylor
3	Simon	Smith	Graham	Smith
4	Bruce	Turner	Graham	Bunce
5	Graham	Smith
6	Graham	Bunce
7
8
9
Main

Cell Formulas
Range	Formula
C2:D4	C2	=FILTER(A2:B10,A2:A10=C1)
Dynamic array formulas.

Hi Fluff and thanks for prompt response.

I made a mistake really, rather than try to explain it all over again, in cell C1 if we just had "aha" for example and then still got the same results. So in short looking for specific text in a line of text.

What you sent me works perfectly which is when I realised I had made a mistake in the original ask.

Hope this makes sense.

Thanks

 

[Fluff]

Ok, how about

=FILTER(A2:B10,ISNUMBER(SEARCH(C1,A2:A10)))

 

[Graham C1600]

Ok, how about

=FILTER(A2:B10,ISNUMBER(SEARCH(C1,A2:A10)))

Works a treat so many thanks.

If I wanted to take this further so perhaps look up aha in C1 first then mit in D1. This would only then bring back Graham Smith.

Would this be difficult ?

Thanks

 

[Fluff]

Try

=FILTER(A2:B10,(ISNUMBER(SEARCH(C1,A2:A10)))*(ISNUMBER(SEARCH(D1,B2:B10))))