Im trying to use VLOOKUP to look up one value and return multiple corresponding values.

I have the following and can return the first and last col by entering =VLOOKUP(A2,A2:B7,2,FALSE) and changing the FALSe to TRUE but I need to be able to return them all.

Ive also had a look at the INDEX function which I don;t know much about but woth this I can only return one of them

=INDEX($A$2:$C$8,SMALL(IF($A$2:$A$8=$A$2,ROW($A$2:$A$8)),ROW(1:8)),2)

A B
10/Jan Taylor Nelson Sofres
10/Jan test
10/Jan test 2
10/Jan test 3
10/Jan test 4
10/Jan test 5

Ive spent all day trying to work this out if anyone can shed any light it would be appreciated!

Thanks, hopefully