Pulling data out of cells using search

[st3ffl3sx13]

Hello,

I have a large database of information that was pulled from a program I use at work. It took all the program and specific device information and put it all in column 'D'. All the cells down column D are linked to a device name as I have a list of all the device names the program uses. What I need is to be able to search the column and in the corresponding column have the name of the device that is found in that cell. So an examples:
If I was looking for all the columns with the device name 'CV-10' in it:
In D10: <TABLE style="WIDTH: 275pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=367><COLGROUP><COL style="WIDTH: 275pt; mso-width-source: userset; mso-width-alt: 13421" width=367><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 275pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=20 width=367>B40147.9^CV-10 AVB MAN PL RAM 00073
In E10: It would display 'CV-10'.

I have 13000 lines of code containing names of over 25 devices so I need something that can assist me with my man hours that it would take me to do this manually.

Any assistance if this is feasible would be greatly appreciated.

Thanks,
-AS
</TD></TR></TBODY></TABLE>

 

[AlphaFrog]

<br />

Book1
	A	B	C	D	E
1	Devices			Data	Device
2	CV-09			B40147.9^CV-10 AVB MAN PL RAM 00073	CV-10
3	CV-10			B40147.9^BC-10 AVB MAN PL RAM 00073	BC-10
4	CB-10			B40147.9^CC-68 AVB MAN PL RAM 00074	CC-68
5	BC-10			B40147.9^ZZ-99 AVB MAN PL RAM 00075	No Match
6	CC-50			B40147.9^CC-60 AVB MAN PL RAM 00076	CC-60
7	CC-51
8	CC-52
9	CC-53
10	CC-54
11	CC-55
12	CC-56
13	CC-57
14	CC-58
15	CC-59
16	CC-60
17	CC-61
18	CC-62
19	CC-63
20	CC-64
21	CC-65
22	CC-66
23	CC-67
24	CC-68
25	CC-69
26	CC-70
27	No Match
Sheet1

<br /><br /><table cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E2</th><td style="text-align:left">{=INDEX(<font color="Blue">$A$1:$A$27,MIN(<font color="Red">IF(<font color="Green">ISNUMBER(<font color="Purple">MATCH(<font color="Teal">"*"&$A$1:$A$27&"*",D2,0</font>)</font>),ROW(<font color="Purple">$A$1:$A$27</font>),27</font>)</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.</td></tr></table>
Copy the formula in E2 down column E