Returnig a set instance after a Succesful Find

[Chip_Excel]

Hi Everyone,
This is what I have in my cells:
<table border="0" cellpadding="0" cellspacing="0" height="15" width="517"><col width="111"><col width="406"><tbody><tr height="17"> <td class="xl155" style="height: 12.75pt; width: 83pt;" height="17" width="111">
</td> <td class="xl155" style="width: 305pt;" width="406">
</td> </tr></tbody></table><table border="0" cellpadding="0" cellspacing="0" width="517"><col width="111"><col width="406"><tbody><tr height="17"> <td class="xl155" style="height: 12.75pt; width: 83pt;" height="17" width="111">Column A</td> <td class="xl155" style="width: 305pt;" width="406">Column B</td> </tr></tbody></table> <table border="0" cellpadding="0" cellspacing="0" width="745"><col style="width: 254pt;" width="339"> <col style="width: 305pt;" width="406"> <tbody><tr style="height: 51pt;" height="68"> <td style="height: 51pt; width: 254pt;" height="68" width="339"> <table border="0" cellpadding="0" cellspacing="0" width="517"><col style="width: 83pt;" width="111"> <col style="width: 305pt;" width="406"> <tbody><tr style="height: 51pt;" height="68"> <td style="height: 51pt; width: 83pt;" height="68" width="111">Toddler/Baby Boy</td> <td class="xl155" style="width: 305pt;" width="406">Toddler/Baby Boy Knits Oct/Nov/Dec11 (Drop)
Newborn Oct/Nov/Dec11 (carry over)
Mens Knits Oct/Nov/Dec11 (Drop)
Boys Knits Oct/Nov/Dec11 (Drop)</td> </tr> <tr style="height: 51pt;" height="68"> <td style="height: 51pt;" height="68">Newborn</td> <td class="xl155" style="border-top: medium none; width: 305pt;" width="406">Toddler/Baby Boy Knits Oct/Nov/Dec11 (Drop)
Newborn Oct/Nov/Dec11 (carry over)
Mens Knits Oct/Nov/Dec11 (Drop)
Boys Knits Oct/Nov/Dec11 (Drop)</td> </tr> <tr style="height: 51pt;" height="68"> <td style="height: 51pt;" height="68">Mens</td> <td class="xl155" style="border-top: medium none; width: 305pt;" width="406">Toddler/Baby Boy Knits Oct/Nov/Dec11 (Drop)
Newborn Oct/Nov/Dec11 (carry over)
Mens Knits Oct/Nov/Dec11 (Drop)
Boys Knits Oct/Nov/Dec11 (Drop)</td> </tr> <tr style="height: 51pt;" height="68"> <td style="height: 51pt;" height="68">Boys</td> <td class="xl155" style="border-top: medium none; width: 305pt;" width="406">Toddler/Baby Boy Knits Oct/Nov/Dec11 (Drop)
Newborn Oct/Nov/Dec11 (carry over)
Mens Knits Oct/Nov/Dec11 (Drop)
Boys Knits Oct/Nov/Dec11 (Drop)
</td> </tr> </tbody></table></td> <td class="xl155" style="width: 305pt;" width="406">
</td> </tr> <tr style="height: 51pt;" height="68"> <td style="height: 51pt;" height="68">
I am trying to write a formula that would find the value in column A within the text of column B, returns the value in parenthesis that occurs directly after it and put in in column C.
So, C1 would return "drop", C2 "carry-over", C3 "drop", and C4 "drop.
Thanks for your help and let me know if you have any questions.
Best,
Chip
</td> <td class="xl155" style="border-top: medium none; width: 305pt;" width="406">
</td> </tr> <tr style="height: 51pt;" height="68"> <td style="height: 51pt;" height="68">
</td> <td class="xl155" style="border-top: medium none; width: 305pt;" width="406">
</td> </tr> <tr style="height: 51pt;" height="68"> <td style="height: 51pt;" height="68">
</td> <td class="xl155" style="border-top: medium none; width: 305pt;" width="406">
</td> </tr> </tbody></table>

 

[alx7000]

Hi Chip,

There may be an easier solution but this one seems to do what I think it is you were after:

Excel Workbook
	A	B	C
1	Toddler/Baby Boy	Toddler/Baby Boy Knits Oct/Nov/Dec11 (Drop) Newborn Oct/Nov/Dec11 (carry over) Mens Knits Oct/Nov/Dec11 (Drop) Boys Knits Oct/Nov/Dec11 (Drop)	Drop
2	Newborn	Toddler/Baby Boy Knits Oct/Nov/Dec11 (Drop) Newborn Oct/Nov/Dec11 (carry over) Mens Knits Oct/Nov/Dec11 (Drop) Boys Knits Oct/Nov/Dec11 (Drop)	carry over
3	Mens	Toddler/Baby Boy Knits Oct/Nov/Dec11 (Drop) Newborn Oct/Nov/Dec11 (carry over) Mens Knits Oct/Nov/Dec11 (Drop) Boys Knits Oct/Nov/Dec11 (Drop)	Drop
4	Boys	Toddler/Baby Boy Knits Oct/Nov/Dec11 (Drop) Newborn Oct/Nov/Dec11 (carry over) Mens Knits Oct/Nov/Dec11 (Drop) Boys Knits Oct/Nov/Dec11 (Drop)	Drop
Sheet1

Excel 2010

Cell Formulas
Range	Formula
C1	=MID(B1,(FIND("(",B1,FIND(A1,B1))+1),(FIND(")",B1,FIND(A1,B1)))-(FIND("(",B1,FIND(A1,B1))+1))

Any questions please let me know.

Cheers,
alx7000

 

[Chip_Excel]

Hi Alx7000,
Worked perfectly. Thank you for your help.
Best,
Chip