Index Aggregate Columns with Multiple Ranges

[jthompson_25]

Hi,

I am trying to adapt the below formula to pull the name of the person from column C (orange), unfortunately the formula returns the value Darren for everything.

Current Excel Formula (not working)
=INDEX($C$5:$C$32,AGGREGATE(15,6,(COLUMN($C$5:$C$32)-COLUMN($C$5)+1)/($D$5:$T$32=E39),1))

Have tried removing absolute values from COLUMN($C$5) with no luck

Thank you in advance for any help provided

 

[Fluff]

Try changing Column to Row.