[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]server1 Name Along with somedata
[/TD]
[TD][/TD]
[TD]server1
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Name along with otherdata server4
[/TD]
[TD][/TD]
[TD]server2
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Somthing server5 other values
[/TD]
[TD][/TD]
[TD]server3
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]server4
[/TD]
[/TR]
</tbody>[/TABLE]
Hello Team,
Here I have a typical question, where in a cell there is a sentance with many strings. i wan to search that cell, wetaher the cell contains any string compared to an array or column of strings. Ex: In A1 , a sting named server1 is there (irrespective of postion). I need to compare the cell with entire C:C and print the matched sting in B1 (i.e server1) and similar B2 (server4), B3 ("No Server").
Please help me.
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]server1 Name Along with somedata
[/TD]
[TD][/TD]
[TD]server1
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Name along with otherdata server4
[/TD]
[TD][/TD]
[TD]server2
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Somthing server5 other values
[/TD]
[TD][/TD]
[TD]server3
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]server4
[/TD]
[/TR]
</tbody>[/TABLE]
Hello Team,
Here I have a typical question, where in a cell there is a sentance with many strings. i wan to search that cell, wetaher the cell contains any string compared to an array or column of strings. Ex: In A1 , a sting named server1 is there (irrespective of postion). I need to compare the cell with entire C:C and print the matched sting in B1 (i.e server1) and similar B2 (server4), B3 ("No Server").
Please help me.