vba - lookup for a value in a range and returns its column header

[Tornado1981]

Hi,
Would anyone plz help me to solve this
I have a table (A1:C5)
A1:C1 contain the table headers
A2:C5 contain the data
A6 contains the value I want to search for
I use this formula to return the column header of A6
A6=INDEX(A1:C1,SUMPRODUCT((A2:C5=A6)*COLUMN(A2:C5)))
Now, if there are duplicate values in A2:C5, this will return more than one column header
What I need is a vba code to view a msgbox with all column headers returned in this case
Thank u in advance

 

[Tornado1981]

any suggestions plz ?