Chosing a list of lists using a formula

[Juizt]

I would like to be able to select a couple of items from list 1 and get whatever belongs to them in list 2 by chosing them in another column.
Example given below:

List1	List2		Chosen list		Output1	Output2
A	Dog		A		A	Dog
A	Cat		C		A	Cat
B	Mouse				C	Dog
C	Dog				C	Mouse
C	Mouse
D	Cat
D	Mouse

I believe this can be done easily using a formula, but I can't seem to find the exact solution, as it keeps on dublicating the wrong output in Output2.
Thank you very much.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	List1	List2		Chosen list		Output1	Output2
2	A	Dog		A		A	Dog
3	A	Cat		C		A	Cat
4	B	Mouse				C	Dog
5	C	Dog				C	Mouse
6	C	Mouse
7	D	Cat
8	D	Mouse
9
Data

Cell Formulas
Range	Formula
F2:G5	F2	=FILTER(A2:B1000,ISNUMBER(MATCH(A2:A1000,D2:D10,0)))
Dynamic array formulas.

 

[Juizt]

Exactly!
Thank you very much for the help.

 

[Fluff]

You're welcome & thanks for the feedback.