search a text and return the column head

[srkreignz]

Hi,

I would like to search for a text in a table and return the column head.

Eg: Table A!:C5

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sl No

[/TD]
[TD] Manager[/TD]
[TD]Trainee[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]John[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Steve [/TD]
[TD]Jeffy[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Harry[/TD]
[TD]Johnson[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Johny[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I wud like to search for john(lower case) in say D2 and get Manger in E2.

Tried the formula
=INDEX(A1:C5,1,MATCH("*"&D2&"*",A2:C5,0))
But not working. Please help !!

 

[srkreignz]

@andrews sir....u made my day
thanks a zillion :D
and a for the patience :D