Looking for help on creating a search...

[wackykat80]

<table border="0" cellpadding="0" cellspacing="0" height="695" width="2947"><colgroup><col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:12507;width:257pt" width="342"> <col style="mso-width-source:userset;mso-width-alt:4461;width:92pt" width="122"> <col style="mso-width-source:userset;mso-width-alt:12507;width:257pt" width="342"> <col style="mso-width-source:userset;mso-width-alt:15835;width:325pt" width="433"> <col style="mso-width-source:userset;mso-width-alt:12507;width:257pt" width="342"> <col style="mso-width-source:userset;mso-width-alt:2450;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt" width="46"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:25892;width:531pt" width="708"> <col style="mso-width-source:userset;mso-width-alt:4205;width:86pt" width="115"> <col style="mso-width-source:userset;mso-width-alt:9801;width:201pt" width="268"> </colgroup><tbody><tr style="height:26.25pt" height="35"> <td class="xl470" style="height:26.25pt;width:74pt" height="35" width="98">SKU</td> <td class="xl470" style="width:257pt" width="342">PRODUCT NAME</td> <td class="xl471" style="width:92pt" width="122">MANUFACTER
NO.</td> <td class="xl459" style="width:257pt" width="342">bullet-point1</td> <td class="xl459" style="width:325pt" width="433">bullet-point2</td> <td class="xl470" style="width:257pt" width="342">DESCRIPTION</td> <td class="xl470" style="width:50pt" width="67">
</td> <td class="xl470" colspan="2" style="mso-ignore:colspan;width:83pt" width="110">PRICE</td> <td class="xl470" style="width:531pt" width="708">IMAGE LINK</td> <td class="xl470" style="width:86pt" width="115">SIZE</td> <td class="xl470" style="width:201pt" width="268">COLOR/FINISH</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl462" style="height:15.0pt" height="20">3222414090</td> <td class="xl468">PULL 224MM CHROME & BLACK</td> <td class="xl461">3222414090</td> <td class="xl467">PULL 224MM CHROME & BLACK</td> <td class="xl463">PULL MET.224MM (M4) CHROME & BLACK</td> <td class="xl463">PULL 224MM CHROME & BLACK</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">44.62</td> <td class="xl458">USD</td> <td class="xl465">http://www.richelieu.com/documentsB/documents/32/22/41/40/90/3222414090/213984_xl.jpg</td> <td class="xl466">224MM</td> <td class="xl469">CHROME & BLACK</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">6216140</td> <td class="xl468">HOOK 16MM CHROME</td> <td class="xl461">6216140</td> <td class="xl467">HOOK 16MM CHROME</td> <td class="xl463">HOOK MET.16MM (WOOD SCREW) CHROME</td> <td class="xl463">HOOK 16MM CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">35.63</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documentsGroupe/105/151/4/1051514/1216845_xl.jpg</td> <td class="xl466">16MM</td> <td class="xl469">CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">621614090</td> <td class="xl468">PULL 16MM CHROME & BLACK</td> <td class="xl461">621614090</td> <td class="xl467">PULL 16MM CHROME & BLACK</td> <td class="xl463">PULL MET.16MM (M4) CHROME & BLACK</td> <td class="xl463">PULL 16MM CHROME & BLACK</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">35.63</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/62/16/14/09/0/621614090/214205_xl.jpg</td> <td class="xl466">16MM</td> <td class="xl469">CHROME & BLACK</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">167128140</td> <td class="xl468">PULL 128MM CHROME</td> <td class="xl461">167128140</td> <td class="xl467">PULL 128MM CHROME</td> <td class="xl463">PULL MET.128MM (M4) CHROME</td> <td class="xl463">PULL 128MM CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">28.34</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/16/71/28/14/0/167128140/213927_xl.jpg</td> <td class="xl466">128MM</td> <td class="xl469">CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">167288140</td> <td class="xl468">PULL 288MM CHROME</td> <td class="xl461">167288140</td> <td class="xl467">PULL 288MM CHROME</td> <td class="xl463">PULL MET.288MM (M4) CHROME</td> <td class="xl463">PULL 288MM CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">46.16</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/16/72/88/14/0/167288140/213951_xl.jpg</td> <td class="xl466">288MM</td> <td class="xl469">CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">10056416140</td> <td class="xl468">PULL 416MM CHROME</td> <td class="xl461">10056416140</td> <td class="xl467">PULL 416MM CHROME</td> <td class="xl463">PULL MET.416MM (M4) CHROME</td> <td class="xl463">PULL 416MM CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">59.20</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/10/05/64/16/14/0/10056416140/213876_xl.jpg</td> <td class="xl466">416MM</td> <td class="xl469">CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">10056160140</td> <td class="xl468">PULL 160MM CHROME</td> <td class="xl461">10056160140</td> <td class="xl467">PULL 160MM CHROME</td> <td class="xl463">PULL MET.160MM (M4) CHROME</td> <td class="xl463">PULL 160MM CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">26.07</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/10/05/61/60/14/0/10056160140/213961_xl.jpg</td> <td class="xl466">160MM</td> <td class="xl469">CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">5736014030</td> <td class="xl468">PULL 16MM CHROME & WHITE</td> <td class="xl461">5736014030</td> <td class="xl467">PULL 16MM CHROME & WHITE</td> <td class="xl463">PULL MET.16MM (M4) CHROME & WHITE</td> <td class="xl463">PULL 16MM CHROME & WHITE</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">29.88</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/57/36/01/40/30/5736014030/213859_xl.jpg</td> <td class="xl466">16MM</td> <td class="xl469">CHROME & WHITE</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">5736014090</td> <td class="xl468">PULL 16MM CHROME & BLACK</td> <td class="xl461">5736014090</td> <td class="xl467">PULL 16MM CHROME & BLACK</td> <td class="xl463">PULL MET.16MM (M4) CHROME & BLACK</td> <td class="xl463">PULL 16MM CHROME & BLACK</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">29.88</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/57/36/01/40/90/5736014090/213900_xl.jpg</td> <td class="xl466">16MM</td> <td class="xl469">CHROME & BLACK</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">57916014030</td> <td class="xl468">PULL 160MM CHROME & WHITE</td> <td class="xl461">57916014030</td> <td class="xl467">PULL 160MM CHROME & WHITE</td> <td class="xl463">PULL MET.160MM (M4) CHROME & WHITE</td> <td class="xl463">PULL 160MM CHROME & WHITE</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">46.97</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/57/91/60/14/03/0/57916014030/213872_xl.jpg</td> <td class="xl466">160MM</td> <td class="xl469">CHROME & WHITE</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">57916014090</td> <td class="xl468">PULL 160MM CHROME & BLACK</td> <td class="xl461">57916014090</td> <td class="xl467">PULL 160MM CHROME & BLACK</td> <td class="xl463">PULL MET.160MM (M4) CHROME & BLACK</td> <td class="xl463">PULL 160MM CHROME & BLACK</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">46.73</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/57/91/60/14/09/0/57916014090/213909_xl.jpg</td> <td class="xl466">160MM</td> <td class="xl469">CHROME & BLACK</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21721714030</td> <td class="xl468">KNOB 24MM CHROME & WHITE</td> <td class="xl461">21721714030</td> <td class="xl467">KNOB 24MM CHROME & WHITE</td> <td class="xl463">KNOB MET.24MM (M4) CHROME & WHITE</td> <td class="xl463">KNOB 24MM CHROME & WHITE</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">14.33</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/72/17/14/03/0/21721714030/192834_xl.jpg</td> <td class="xl466">24MM</td> <td class="xl469">CHROME & WHITE</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21721714090</td> <td class="xl468">KNOB 24MM CHROME & BLACK</td> <td class="xl461">21721714090</td> <td class="xl467">KNOB 24MM CHROME & BLACK</td> <td class="xl463">KNOB MET.24MM (M4) CHROME & BLACK</td> <td class="xl463">KNOB 24MM CHROME & BLACK</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">14.33</td> <td class="xl460">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/72/17/14/09/0/21721714090/192597_xl.jpg</td> <td class="xl466">24MM</td> <td class="xl469">CHROME & BLACK</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">61696764174</td> <td class="xl468">PULL 64MM CC MAT CHROME</td> <td class="xl461">61696764174</td> <td class="xl467">PULL 64MM CC MAT CHROME</td> <td class="xl463">PULL MET.64MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 64MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">11.17</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/61/69/67/64/17/4/61696764174/212561_xl.jpg</td> <td class="xl466">64MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">61644332174</td> <td class="xl468">KNOB 32MM MAT CHROME</td> <td class="xl461">61644332174</td> <td class="xl467">KNOB 32MM MAT CHROME</td> <td class="xl463">KNOB MET.32MM (M4) MAT CHROME</td> <td class="xl463">KNOB 32MM MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">8.25</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/61/64/43/32/17/4/61644332174/188171_xl.jpg</td> <td class="xl466">32MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">61696732174</td> <td class="xl468">PULL 32MM CC MAT CHROME</td> <td class="xl461">61696732174</td> <td class="xl467">PULL 32MM CC MAT CHROME</td> <td class="xl463">PULL MET.32MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 32MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">9.23</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/61/69/67/32/17/4/61696732174/212560_xl.jpg</td> <td class="xl466">32MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21696192174</td> <td class="xl468">PULL 192MM CC MAT CHROME</td> <td class="xl461">21696192174</td> <td class="xl467">PULL 192MM CC MAT CHROME</td> <td class="xl463">PULL MET.192MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 192MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">25.27</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/69/61/92/17/4/21696192174/212517_xl.jpg</td> <td class="xl466">192MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21696160174</td> <td class="xl468">PULL 160MM CC MAT CHROME</td> <td class="xl461">21696160174</td> <td class="xl467">PULL 160MM CC MAT CHROME</td> <td class="xl463">PULL MET.160MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 160MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">20.22</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/69/61/60/17/4/21696160174/212512_xl.jpg</td> <td class="xl466">160MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21696128174</td> <td class="xl468">PULL 128MM CC MAT CHROME</td> <td class="xl461">21696128174</td> <td class="xl467">PULL 128MM CC MAT CHROME</td> <td class="xl463">PULL MET.128MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 128MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">16.34</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/69/61/28/17/4/21696128174/212511_xl.jpg</td> <td class="xl466">128MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21702224174</td> <td class="xl468">PULL 224MM CC MAT CHROME</td> <td class="xl461">21702224174</td> <td class="xl467">PULL 224MM CC MAT CHROME</td> <td class="xl463">PULL MET.224MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 224MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">29.61</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/70/22/24/17/4/21702224174/212538_xl.jpg</td> <td class="xl466">224MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21702160174</td> <td class="xl468">PULL 160MM CC MAT CHROME</td> <td class="xl461">21702160174</td> <td class="xl467">PULL 160MM CC MAT CHROME</td> <td class="xl463">PULL MET.160MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 160MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">20.85</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/70/21/60/17/4/21702160174/212528_xl.jpg</td> <td class="xl466">160MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">2170296174</td> <td class="xl468">PULL 96MM CC MAT CHROME</td> <td class="xl461">2170296174</td> <td class="xl467">PULL 96MM CC MAT CHROME</td> <td class="xl463">PULL MET.96MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 96MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">15.33</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/70/29/61/74/2170296174/212431_xl.jpg</td> <td class="xl466">96MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21691128174</td> <td class="xl468">PULL 128MM CC MAT CHROME</td> <td class="xl461">21691128174</td> <td class="xl467">PULL 128MM CC MAT CHROME</td> <td class="xl463">PULL MET.128MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 128MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">15.54</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/69/11/28/17/4/21691128174/212509_xl.jpg</td> <td class="xl466">128MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">2169164174</td> <td class="xl468">PULL 64MM CC MAT CHROME</td> <td class="xl461">2169164174</td> <td class="xl467">PULL 64MM CC MAT CHROME</td> <td class="xl463">PULL MET.64MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 64MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">12.93</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/69/16/41/74/2169164174/212414_xl.jpg</td> <td class="xl466">64MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">2169132174</td> <td class="xl468">PULL 32MM CC MAT CHROME</td> <td class="xl461">2169132174</td> <td class="xl467">PULL 32MM CC MAT CHROME</td> <td class="xl463">PULL MET.32MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 32MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">10.76</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/69/13/21/74/2169132174/212413_xl.jpg</td> <td class="xl466">32MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">216423175</td> <td class="xl468">PULL 96MM VELVET CHROME</td> <td class="xl461">216423175</td> <td class="xl467">PULL 96MM VELVET CHROME</td> <td class="xl463">PULL MET.96MM (M4) VELVET CHROME</td> <td class="xl463">PULL 96MM VELVET CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">18.51</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/64/23/17/5/216423175/214263_xl.jpg</td> <td class="xl466">96MM</td> <td class="xl469">VELVET CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl462" style="height:15.0pt" height="20">30373175</td> <td class="xl468">KNOB 32MM BRUSHED CHROME</td> <td class="xl462">30373175</td> <td class="xl467">KNOB 32MM BRUSHED CHROME</td> <td class="xl463">KNOB MET.32MM (8/32) BRUSHED CHROME</td> <td class="xl463">KNOB 32MM BRUSHED CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">4.37</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/BP/30/37/31/85/BP30373185/214323_xl.jpg</td> <td class="xl466">32MM</td> <td class="xl469">BRUSHED CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">79222174</td> <td class="xl468">KNOB 22MM MAT CHROME</td> <td class="xl461">79222174</td> <td class="xl467">KNOB 22MM MAT CHROME</td> <td class="xl463">KNOB MET.22MM (M4) MAT CHROME</td> <td class="xl463">KNOB 22MM MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">14.66</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/79/22/21/74/79222174/174118_xl.jpg</td> <td class="xl466">22MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">79216174</td> <td class="xl468">PULL 16MM MAT CHROME</td> <td class="xl461">79216174</td> <td class="xl467">PULL 16MM MAT CHROME</td> <td class="xl463">PULL MET.16MM (M4) MAT CHROME</td> <td class="xl463">PULL 16MM MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">18.97</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/79/21/61/74/79216174/209696_xl.jpg</td> <td class="xl466">16MM</td> <td class="xl469">MAT CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21683160140</td> <td class="xl468">PULL 160MM CC CHROME</td> <td class="xl461">21683160140</td> <td class="xl467">PULL 160MM CC CHROME</td> <td class="xl463">PULL MET.160MM CC (M4) CHROME</td> <td class="xl463">PULL 160MM CC CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">24.48</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/68/31/60/14/0/21683160140/1109174_xl.jpg</td> <td class="xl466">160MM</td> <td class="xl469">CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21683192140</td> <td class="xl468">PULL 192MM CC CHROME</td> <td class="xl461">21683192140</td> <td class="xl467">PULL 192MM CC CHROME</td> <td class="xl463">PULL MET.192MM CC (M4) CHROME</td> <td class="xl463">PULL 192MM CC CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">28.33</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/68/31/92/14/0/21683192140/1109175_xl.jpg</td> <td class="xl466">192MM</td> <td class="xl469">CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21724352140</td> <td class="xl468">PULL 352MM CC CHROME</td> <td class="xl461">21724352140</td> <td class="xl467">PULL 352MM CC CHROME</td> <td class="xl463">PULL MET.352MM CC (M4) CHROME</td> <td class="xl463">PULL 352MM CC CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">63.15</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/72/43/52/14/0/21724352140/1110611_xl.jpg</td> <td class="xl466">352MM</td> <td class="xl469">CHROME</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl461" style="height:15.0pt" height="20">21724352174</td> <td class="xl468">PULL 352MM CC MAT CHROME</td> <td class="xl461">21724352174</td> <td class="xl467">PULL 352MM CC MAT CHROME</td> <td class="xl463">PULL MET.352MM CC (M4) MAT CHROME</td> <td class="xl463">PULL 352MM CC MAT CHROME</td> <td class="xl458">Hardware</td> <td class="xl464" align="right">63.30</td> <td class="xl458">USD</td> <td>http://www.richelieu.com/documentsB/documents/21/72/43/52/17/4/21724352174/1108869_xl.jpg</td> <td class="xl466">352MM</td> <td class="xl469">MAT CHROME
</td> </tr> </tbody></table>

 

[wackykat80]

For example SKU starts on A1(numbers cont' thru A34)
and the rest will follow. I have googled a ton of stuff and basically I found some formulas and how to's to create V-codes. However the information doesn't seem to apply to what I have. In reference to the table I submitted I'm looking to do a search that finds exactly what the ROW 1 has for titles (Ex: sku, manufacter no. color/finish, size,). From the original spreadsheet I created another sheet to work with to create the search function...but I'm stuck? Please help...

 

[VoG]

VLOOKUP should work

Excel Workbook
	A	B	C	D
1	SKU	5736014030	PULL 16MM CHROME & WHITE
2
3
4	3222414090	PULL 224MM CHROME & BLACK	3222414090	PULL 224MM CHROME & BLACK
5	6216140	HOOK 16MM CHROME	6216140	HOOK 16MM CHROME
6	621614090	PULL 16MM CHROME & BLACK	621614090	PULL 16MM CHROME & BLACK
7	167128140	PULL 128MM CHROME	167128140	PULL 128MM CHROME
8	167288140	PULL 288MM CHROME	167288140	PULL 288MM CHROME
9	10056416140	PULL 416MM CHROME	10056416140	PULL 416MM CHROME
10	10056160140	PULL 160MM CHROME	10056160140	PULL 160MM CHROME
11	5736014030	PULL 16MM CHROME & WHITE	5736014030	PULL 16MM CHROME & WHITE
12	5736014090	PULL 16MM CHROME & BLACK	5736014090	PULL 16MM CHROME & BLACK
13	57916014030	PULL 160MM CHROME & WHITE	57916014030	PULL 160MM CHROME & WHITE
14	57916014090	PULL 160MM CHROME & BLACK	57916014090	PULL 160MM CHROME & BLACK
15	21721714030	KNOB 24MM CHROME & WHITE	21721714030	KNOB 24MM CHROME & WHITE
16	21721714090	KNOB 24MM CHROME & BLACK	21721714090	KNOB 24MM CHROME & BLACK
17	61696764174	PULL 64MM CC MAT CHROME	61696764174	PULL 64MM CC MAT CHROME
18	61644332174	KNOB 32MM MAT CHROME	61644332174	KNOB 32MM MAT CHROME
19	61696732174	PULL 32MM CC MAT CHROME	61696732174	PULL 32MM CC MAT CHROME
20	21696192174	PULL 192MM CC MAT CHROME	21696192174	PULL 192MM CC MAT CHROME
21	21696160174	PULL 160MM CC MAT CHROME	21696160174	PULL 160MM CC MAT CHROME
22	21696128174	PULL 128MM CC MAT CHROME	21696128174	PULL 128MM CC MAT CHROME
23	21702224174	PULL 224MM CC MAT CHROME	21702224174	PULL 224MM CC MAT CHROME
24	21702160174	PULL 160MM CC MAT CHROME	21702160174	PULL 160MM CC MAT CHROME
25	2170296174	PULL 96MM CC MAT CHROME	2170296174	PULL 96MM CC MAT CHROME
26	21691128174	PULL 128MM CC MAT CHROME	21691128174	PULL 128MM CC MAT CHROME
27	2169164174	PULL 64MM CC MAT CHROME	2169164174	PULL 64MM CC MAT CHROME
28	2169132174	PULL 32MM CC MAT CHROME	2169132174	PULL 32MM CC MAT CHROME
29	216423175	PULL 96MM VELVET CHROME	216423175	PULL 96MM VELVET CHROME
30	30373175	KNOB 32MM BRUSHED CHROME	30373175	KNOB 32MM BRUSHED CHROME
31	79222174	KNOB 22MM MAT CHROME	79222174	KNOB 22MM MAT CHROME
32	79216174	PULL 16MM MAT CHROME	79216174	PULL 16MM MAT CHROME
33	21683160140	PULL 160MM CC CHROME	21683160140	PULL 160MM CC CHROME
34	21683192140	PULL 192MM CC CHROME	21683192140	PULL 192MM CC CHROME
35	21724352140	PULL 352MM CC CHROME	21724352140	PULL 352MM CC CHROME
36	21724352174	PULL 352MM CC MAT CHROME	21724352174	PULL 352MM CC MAT CHROME
Sheet2

Tutorial: http://www.contextures.com/xlFunctions02.html

 

[wackykat80]

Oh my god I think my brain just went crash. Maybe I'm not using the Vlookup right. I need to create a search engine? to find either sku's colors whether it's a pull or a knob..etc. Like when we use an online store to search for what we want, then a list pops up with options? Please help???

 

[wackykat80]

ok here is another question...how do I extract the first word ex: PULL from the description? I used =left(J56,FIND(")",J56,1)+2,250)...it didn't work??

 

[VoG]

Try

=LEFT(J56,FIND(" ",J56)-1)