Index function with duplicate Data.
 

Hi,

I am trying to get a formula that will return the date (column C) into column F using the lookup value (unique value), but as you can see, there are duplicate codes for the add code, which have different dates. I would like it so that the formula looks up the first lookup up code, then pulls through the date for the first code, then if there is another add code but a different code for it to the pull that date through but have it in column G (2nd) and H (3rd). In essence, I would like to see how many times the add code appears and if its more than once, to place it along in columns F, G and H.

I have tried lookups, Index, Index with rows, 2 way lookups, I just cant seem to get it to work so that it looks down the rows and pulls through the correct dates for the add code and if there are duplicates to place them side by side.

As you can see Add code 123 has code 1,2 and 6.

=index($D$1:$D$6,small(if($B$1:$B$6=$F$1,if($A$1:$ A$6=$E$1:$E$5,row($D$1:$D$6)-row($D$1)-1))))


Any help would be greatly appreciated.

Many thanks in advanced.

:)