Vlookup multiple instances of Lookup Value

Hey all

I am using this formula

Please Login or Register  to view this content.

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

Hello,

H4, use this Array Formula, must hit CONTROL+SHIFT+ENTER, not just ENTER. then copy across & down.

=IFERROR(INDEX(C:C,SMALL(IF($B$4:$B$11=$G4,ROW($B$4:$B$11)),COUNTIF($G$4:$G4,$G4))),"")

Thanks H. Thats great