Returnig a set instance after a Succesful Find

Chip_Excel

New Member
Joined
Jul 20, 2010
Messages
8
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>
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

alx7000

Board Regular
Joined
Nov 14, 2010
Messages
134
Hi Chip,

There may be an easier solution but this one seems to do what I think it is you were after:
Excel Workbook
ABC
1Toddler/Baby BoyToddler/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
2NewbornToddler/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
3MensToddler/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
4BoysToddler/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
RangeFormula
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
 

Watch MrExcel Video

Forum statistics

Threads
1,133,428
Messages
5,658,736
Members
418,467
Latest member
sc356448

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top