VLOOKUP to show all results, instead of first matching one

[whatever61]

I have the following table:

title	data
HK	A
CC	B
HK	C

I want another table that will show me results based on the selection in the title column.
So if I put HK it will show me a list of results where the title is HK.

I tried to do it with VLOOKUP, but it always shows me the first result. Like this:

A

A

And I want it to show:

A

C

Thanks!

[GeneralDisarray]

Try the idea applied here: http://www.excelforum.com/excel-form...ml#post2921044


Check out the attachment. Change the E4 cell value, you will get a list beneath that for the matched values.

[whatever61]

Thanks, I've tried it, but I don't manage to do Report 3rd.

This is the formula for the Report 2nd:

=INDEX(INDEX($A$4:$A$330,1+MATCH(D4,$A$4:$A$330,0),1):$B$330,MATCH(D4,INDEX($A$4:$A$330,1+MATCH(D4,$A$4:$A$330,0),1):$A$330,0),2)

Tried to change both 1+MATCH to 2+MATCH, doesn't work.

[hoyasaxa215]

Try using this array formula.

[whatever61]

YYYYYYYYYYYYYEEEEEEEEEEEESSSSSSS!

Thanks

[GeneralDisarray]

Sorry, when i was adjusting my example for your version of the problem I should have subtracted 2 not 3:

{=IF(D4>SUMPRODUCT(IF(keyCol=E$3,1,0)*IF(keyCol=E$3,1,0)),"",INDEX(scores,SMALL(IF(keyCol=E$3,ROW(keyCol)-2,FALSE),D4),1))}

Looks like hoasaxa beat me to the punch with another solution