How to search match values from 2 different worksheets

pikpik · Jun 19, 2010

Hi everyone,

I have a problem with the formula that I created.

I want to search value by comparing 2 tables on worksheet A and worksheet B and return the result from worksheet A to worksheet B.

Worksheet B is the details and each detail will contains the value which are listed on worksheet A. Thus, if the value is match, it will display the result (categories) on worksheet B.

I marked all values on worksheet A and B with red color on tables below.

Formula : =IF(ISNUMBER(SEARCH(Worksheet A!$A$2,Worksheet B!A1)),Worksheet A!$B$2,IF(ISNUMBER(SEARCH(Worksheet A!$A$3,Worksheet B!A1)),Worksheet A!$B$3,IF(ISNUMBER(SEARCH(Worksheet A!$A$4,Worksheet B!A1)),Worksheet A!$B$4,IF(ISNUMBER(SEARCH(Worksheet A!$A$5,Worksheet B!A1)),Worksheet A!$B$5,IF(ISNUMBER(SEARCH(Worksheet A!$A$6,Worksheet B!A1)),Worksheet A!$B$6,IF(ISNUMBER(SEARCH(Worksheet A!$A$7,Worksheet B!A1)),Worksheet A!$B$7,IF(ISNUMBER(SEARCH(Worksheet A!$A$8,Worksheet B!A1)),Worksheet A!$B$8,IF(ISNUMBER(SEARCH(Worksheet A!$A$9,Worksheet B!A1)),Worksheet A!$B$9,IF(ISNUMBER(SEARCH(Worksheet A!$A$10,Worksheet B!A1)),Worksheet A!$B$10,IF(ISNUMBER(SEARCH(Worksheet A!$A$11,Worksheet B!A1)),Worksheet A!$B$11,IF(ISNUMBER(SEARCH(Worksheet A!$A$12,Worksheet B!A1)),Worksheet A!$B$12,IF(ISNUMBER(SEARCH(Worksheet A!$A$13,Worksheet B!A1)),Worksheet A!$B$13,IF(ISNUMBER(SEARCH(Worksheet A!$A$14,Worksheet B!A1)),Worksheet A!$B$14,IF(ISNUMBER(SEARCH(Worksheet A!$A$15,Worksheet B!A1)),Worksheet A!$B$15,IF(ISNUMBER(SEARCH(Worksheet A!$A$16,Worksheet B!A1)),Worksheet A!$B$16,IF(ISNUMBER(SEARCH(Worksheet A!$A$17,Worksheet B!A1)),Worksheet A!$B$17,IF(ISNUMBER(SEARCH(Worksheet A!$A$18,Worksheet B!A1)),Worksheet A!$B$18,IF(ISNUMBER(SEARCH(Worksheet A!$A$19,Worksheet B!A1)),Worksheet A!$B$19,IF(ISNUMBER(SEARCH(Worksheet A!$A$20,Worksheet B!A1)),Worksheet A!$B$20,"NOT OK")))))))))))))))))))

When I use this formula, error message prompted: "The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format."

What formula can I use to get the result?

Worksheet A
<link rel="File-List" href="file:///C:%5CUsers%5CEtza%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CEtza%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CEtza%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format

ther; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0cm; margin-right:0cm; margin-bottom:10.0pt; margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <table class="MsoTableGrid" style="border-collapse: collapse; border: medium none;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]<o> </o>[/FONT]
</td> <td style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Column A<o></o>[/FONT]
</td> <td style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Column B<o></o>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 1<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]NAME<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]CATEGORIES<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 2<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]shirt<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]TOP<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 3<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]t-shirt<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]TOP<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 4<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]blouse<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]TOP<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 5<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]pants<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 6<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]skirt<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 7<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]short<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 8<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]dress<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]DRESS<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 9<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]long coat<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]OUTER<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 10<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]top<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]TOP<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 11<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]bgm<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BAG<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 12[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]jacket<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]OUTER<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 13[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]coat<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]OUTER<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 14[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]jumpsuit<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]JUMPSUIT<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 15[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]trouser<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]JUMPSUIT/BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 16[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]high waist<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 17[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]belt<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]ACC<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 18[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]cap<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]ACC<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 19[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]hat<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]ACC<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 20[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]girdle<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]ACC<o

></o

>[/FONT]
</td> </tr> </tbody></table>
Worksheet B
<link rel="File-List" href="file:///C:%5CUsers%5CEtza%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CEtza%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CEtza%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format

ther; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0cm; margin-right:0cm; margin-bottom:10.0pt; margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <table class="MsoTableGrid" style="border-collapse: collapse; border: medium none;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]<o> </o>[/FONT]
</td> <td style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Column A<o></o>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 1<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]purple lace ball princess dress sense Erjian Shi (a total of three colors)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 2<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]black irregular wrinkle dress hem section a total of two-color<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 3<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Black Cross V Neck Long leave Erjian Shi T-shirt (a total of four-color)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 4<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]gray cross-V-Neck Long leave Erjian Shi T-shirt (a total of four-color)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 5<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Long navy blue lace jacket (a total of three colors)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 6<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]white lace shirt long version (a total of three colors)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 7<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Elastic waist jeans wild blue trousers paragraph (a total of two-color)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 8<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]black casual line terms Pants (a total of three colors)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 9<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]white terms Pants Casual line (a total of three colors)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 10<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]red mosaic three-color sense of a simple side Shoulder Bag (a total of four-color)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 11.95pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 11.95pt;" valign="top"> [FONT=&quot]Row 11<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 11.95pt;" valign="top" nowrap="nowrap"> [FONT=&quot]pink mosaic three-color sense of a simple side Shoulder Bag (a total of four-color)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 12[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]light mature sense of zebra coat<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 13[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]white can love a child diagram shirt cap<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 14[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]black irregular wrinkle dress hem section a total of two-color<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 15[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]sweet three-dimensional flower belt paragraph a total of three colors<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 16[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]dynamic sense of double-breasted models shorts<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 17[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]yellow elastic waist Floral Skirt paragraph (a total of two-color)<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 18[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Japanese Vintage. High waist jeans<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> Row 19<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Japanese lace girdle pressure off a total of three colors<o

></o

>[/FONT]
</td> </tr> </tbody></table>
Result will display on worksheet B
<link rel="File-List" href="file:///C:%5CUsers%5CEtza%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CEtza%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CEtza%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format

ther; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0cm; margin-right:0cm; margin-bottom:10.0pt; margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <table class="MsoTableGrid" style="border-collapse: collapse; border: medium none;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]<o> </o>[/FONT]
</td> <td style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Column A<o></o>[/FONT]
</td> <td style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Column B<o></o>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 1<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]purple lace ball princess dress sense Erjian Shi (a total of three colors)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]DRESS<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 2<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]black irregular wrinkle dress hem section a total of two-color<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]DRESS<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 3<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Black Cross V Neck Long leave Erjian Shi T-shirt (a total of four-color)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]TOP<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 4<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]gray cross-V-Neck Long leave Erjian Shi T-shirt (a total of four-color)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]TOP<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 5<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Long navy blue lace jacket (a total of three colors)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]OUTER<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 6<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]white lace shirt long version (a total of three colors)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]TOP<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 7<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Elastic waist jeans wild blue trousers paragraph (a total of two-color)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 8<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]black casual line terms Pants (a total of three colors)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 9<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]white terms Pants Casual line (a total of three colors)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 10<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]red mosaic three-color sense of a simple side Shoulder Bag (a total of four-color)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BAG<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 11<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]pink mosaic three-color sense of a simple side Shoulder Bag (a total of four-color)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BAG<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 12[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]light mature sense of zebra coat<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]OUTER<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 13[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]white can love a child diagram shirt cap<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]ACCESSORIES<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 14[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]black irregular wrinkle dress hem section a total of two-color<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]JUMPSUIT<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 15[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]sweet three-dimensional flower belt paragraph a total of three colors<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]ACCESSORIES<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 16[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]dynamic sense of double-breasted models shorts<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 17[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]yellow elastic waist Floral Skirt paragraph (a total of two-color)<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 18[/FONT]<o></o>
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Japanese Vintage. High waist jeans<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]BOTTOM<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color black black; padding: 0cm 5.4pt; height: 12.75pt;" valign="top"> [FONT=&quot]Row 19<o></o>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]Japanese lace girdle pressure off a total of three colors<o

></o

>[/FONT]
</td> <td style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0cm 5.4pt; height: 12.75pt;" valign="top" nowrap="nowrap"> [FONT=&quot]ACCESSORIES<o

></o

>[/FONT]
</td> </tr> </tbody></table>
Please help me... Thank you.

shift-del · Jun 19, 2010

Hi

=INDEX(Sheet1!$B$2:$B$20,MATCH(TRUE,ISNUMBER(SEARCH(Sheet1!$A$2:$A$20,A1)),0))

Array formula!
Enter with CTRL-SHIFT-ENTER!

pikpik · Jun 19, 2010

thanks shift-del...but..it is not working... could it be because of search isn't for array?

shift-del · Jun 19, 2010

It works for me.

<table valign="middle" colspan="3" style="font-family: Calibri; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11px; font-weight: normal; font-style: normal;" border="1" cellpadding="2" cellspacing="0"><colgroup><col width="28pt"><col width="390,75pt"><col width="96,75pt"></colgroup><tbody><tr style="background-color: rgb(250, 250, 250);"><td colspan="3" align="middle">Arbeitsblatt mit dem Namen 'Sheet2'</td></tr><tr style="background-color: rgb(202, 202, 202);"><td>
</td><td align="middle">A</td><td align="middle">B</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">1</td><td style="" align="left">purple lace ball princess dress sense Erjian Shi (a total of three colors)</td><td align="left">DRESS</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">2</td><td style="" align="left">black irregular wrinkle dress hem section a total of two-color</td><td align="left">DRESS</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">3</td><td style="" align="left">Black Cross V Neck Long leave Erjian Shi T-shirt (a total of four-color)</td><td align="left">TOP</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">4</td><td style="" align="left">gray cross-V-Neck Long leave Erjian Shi T-shirt (a total of four-color)</td><td align="left">TOP</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">5</td><td style="" align="left">Long navy blue lace jacket (a total of three colors)</td><td align="left">OUTER</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">6</td><td style="" align="left">white lace shirt long version (a total of three colors)</td><td align="left">TOP</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">7</td><td style="" align="left">Elastic waist jeans wild blue trousers paragraph (a total of two-color)</td><td align="left">JUMPSUIT/BOTTOM</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">8</td><td style="" align="left">black casual line terms Pants (a total of three colors)</td><td align="left">BOTTOM</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">9</td><td style="" align="left">white terms Pants Casual line (a total of three colors)</td><td align="left">BOTTOM</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">10</td><td style="" align="left">red mosaic three-color sense of a simple side Shoulder Bag (a total of four-color)</td><td align="right">#NV</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">11</td><td style="" align="left">pink mosaic three-color sense of a simple side Shoulder Bag (a total of four-color)</td><td align="right">#NV</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">12</td><td style="" align="left">light mature sense of zebra coat</td><td align="left">OUTER</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">13</td><td style="" align="left">white can love a child diagram shirt cap</td><td align="left">TOP</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">14</td><td style="" align="left">black irregular wrinkle dress hem section a total of two-color</td><td align="left">DRESS</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">15</td><td style="" align="left">sweet three-dimensional flower belt paragraph a total of three colors</td><td align="left">ACC</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">16</td><td style="" align="left">dynamic sense of double-breasted models shorts</td><td align="left">BOTTOM</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">17</td><td style="" align="left">yellow elastic waist Floral Skirt paragraph (a total of two-color)</td><td align="left">BOTTOM</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">18</td><td style="" align="left">Japanese Vintage. High waist jeans</td><td align="left">BOTTOM</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">19</td><td style="" align="left">Japanese lace girdle pressure off a total of three colors</td><td align="left">ACC</td></tr></tbody></table>
<table valign="middle" colspan="2" style="table-layout: auto; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; font-size: 10px;" border="3" cellpadding="2" cellspacing="0"><colgroup><col width="40pt"><col></colgroup><tbody><tr style="background-color: rgb(238, 170, 170);"><td>Zelle</td><td>Formel</td></tr><tr><td>B1</td><td>{=INDEX(Sheet1!$B$2:$B$20,MATCH(TRUE,ISNUMBER(SEARCH(Sheet1!$A$2:$A$20,A1)),0))}</td></tr></tbody></table><table style="font-family: Arial; font-size: 8pt; background-color: rgb(255, 255, 255);"><tbody><tr><td style="font-weight: bold;">Attention, contains array formula!</td></tr><tr><td>Do not enter the curly brackets {}..</td></tr><tr><td>Enter the formular with CTRL-SHIFT-ENTER instead of just ENTER.</td></tr></tbody></table><table style="font-family: Arial; font-size: 7pt;"><tbody><tr><td style="color: rgb(51, 51, 51);">Created and displayed with Tab2HTML (v2.4.1). ©Gerd alias Bamberg</td></tr></tbody></table>

pikpik · Jun 19, 2010

thanks a lot shift-del...i didn't enter the formula with CTRL-SHIFT-ENTER...
it works fine now...

thank you so much for your help =D

How to search match values from 2 different worksheets

pikpik

New Member

shift-del

Well-known Member

pikpik

New Member

shift-del

Well-known Member

pikpik

New Member

Similar threads

Share this page

How to search match values from 2 different worksheets

pikpik

New Member

shift-del

Well-known Member

pikpik

New Member

shift-del

Well-known Member

pikpik

New Member

Similar threads

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock