Snasui Excel Forum

Hi Dear,

I need your assistance how to populate data all the way down with no blank base on header.

For example if I type A it shall populate data in column contains A as in highlights


Thanks

...

A12

=IFERROR(INDEX($A$3:$D$9,AGGREGATE(15,6,ROW($A$3:$A$9)/($A$3:$D$9<>"")/($A$11=$A$2:$D$2),ROWS($A$12:A12))-ROW($A$2),MATCH($A$11,$A$2:$D$2,0)),"")

Norkaz

Thank you