Column Heading

[sathishkm]

Hi All,

I have the email list clubbed in the columns. Here I need to columns heading to be in updated based on the email address. Please find the attachment which I had highlighted in yellow color.

[Andy Pope]

=index($b$1:$e$1,1,sumproduct(($b$2:$e$11=h2)*column($b$2:$e$11))-column($b$2:$e$11)+1)