Need to get multiple values based on a single value

I have a table that contains company to company transactions and need to reconcile.

Instead of using a vlookup that only returns the first match, I need to get all transactions for a single company.

Here's the formula I've started with. It works fine for the first item it finds, but doesn't return any values afterwards. (e.g 2nd, 3rd instance. Also, when I don't make it an array formula it doesn't return anything.)

=IF(ISERROR(INDEX('DATA-CVB'!$C$4:$Q$1000,SMALL(IF('DATA-CVB'!$C$4:$C$1000=$B$6,ROW('DATA-CVB'!$C$4:$C$1000)),ROW('DATA-CVB'!4:4)),6)),"",INDEX('DATA-CVB'!$C$4:$Q$1000,SMALL(IF('DATA-CVB'!$C$4:$C$1000=$B$6,ROW('DATA-CVB'!$C$4:$C$1000)),ROW('DATA-CVB'!4:4)),6))

In this case, I'm trying to match the value in B6 of current worksheet to a list found in worksheet DATA-CVB. Whenit finds a match, I want the value found in the 6th column of the row it found the data in.

Any ideas?