I am putting in a postcode in Cell C6 = 4000

My formula to look up the postcode in Cell C6 is
=IF(ISERROR(VLOOKUP($C$6,TNI,3,FALSE)),"",(VLOOKUP ($C$6,TNI,3,FALSE)))

I want the formula to look up all the postcodes that are 4000 in this Table
and return the code QCBD/QBMH, QBMH

TNI look up table has the same post code yet differeent valuse next to it eg
A B C
4000 Brisbane QCBD/QBMH
4000 Spring Hill QBMH
4004 All suburbs QBMH
4005 All suburbs QBMH

At the moment my current formula only returns QCBD/QBMH

Is tehre any way that i cna get it to return the whole lot QCBD/QBMH, QBMH
as there are 2 areas in the same postcode.

IN a seperate cell I will also need to return the different suburbs in the
same cell for same post code is this the same

Thanks

Mick