Find a value in an array and return multiple values in an adjacent array

Hi

The {} relate to the formula being array entered. Edit the formula, then hold down the ctrl and shift keys together, then press the enter key. You will find that the resulting formula will have the {}

Actually, your formula hasn't been updated for the revised positions. The formula for E13 should be =IF(COUNTIF($A$13:$A$20,$D13)<COLUMN(A$12),"",INDEX($B$13:$B$20,IF(COUNTIF($A$13:$A$20,$D13)>=COLUMNS($E12:E$12),SMALL(IF($D13=$A$13:$A$20,ROW($B$13:$B$20)-12,""),COLUMNS($E12:E$12)),""),1))


HTH

rylo