date reference and copy range

[nnish]

hi,

i want to copy-past value from B and C column to F and E column. But need to reference D2 and A column date value .

[JohnTopley]

In E2

=IFERROR(INDEX($C$2:$C$21,SMALL(IF($A$2:$A$21=$D$2,ROW($A$2:$A$21)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

Enter with Ctrl+Shift+Enter

Drag down until you get blank cells

[Tony Valko]

Try this...

Entered in E2:

=IF(ROWS(E$2:E2)>COUNTIF(A:A,D$2),"",INDEX(C:C,MATCH(D$2,A:A,0)+ROWS(E$2:E2)-1))

Copy down until you get blanks.

[nnish]

Thanks sir, Both are working.

[Tony Valko]

You're welcome. Thanks for the feedback!