Tornado1981
Board Regular
- Joined
- Apr 1, 2010
- Messages
- 248
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
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