Find column header

[Aussiebear]

I am trying to find the column header of a cell which matches a particular value, however the formula that I'm using in Cell T2 is returning a "Value" error. Could someone show me where I am going wrong please?

Cell S2 is the value to match within the range B2:R2 and I'm expecting the T2 formula to return the value "Grenville"

[Aussiebear]

Never mind. I was using a formula
=Index($B$1:$S$1,,Sumproduct(($B3:$S3=T3)*Column($B3:$S3)-Column($A3) and have changed that to
=Index(B$1:$S$1,,Match(T3,$B3:$S3,0)) which works.