Vlookup multiple instances of Lookup Value

Hey all

I am using this formula

=VLOOKUP($F4,$A$4:$D$11,COLUMNS($A$1:B$1),0)

to extract data from a table, however, the cust id in F4 is also repeated further down the table with different values in B;D.

This type of lookup only returns the first instance.

Can anyone point me into the right direction of a formula which will pick up multiple instances. I've got a feeling that its an if rows countif small index match type one!

please see the attached


Cheers fellas