# How to search match values from 2 different worksheets

#### pikpik

##### New Member
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
</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
</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
</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>

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### shift-del

##### Well-known Member
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

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

#### shift-del

##### Well-known Member
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

##### New Member
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

Replies
9
Views
761
Replies
6
Views
388
Replies
1
Views
346
Replies
1
Views
401
Replies
17
Views
747

1,127,334
Messages
5,624,081
Members
416,010
Latest member
NJT

### 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.

### Which adblocker are you using?

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

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