<table border="0" cellpadding="0" cellspacing="0" width="629"><col style="width: 65pt;" width="87"> <col style="width: 92pt;" width="122"> <col style="width: 46pt;" width="61"> <col style="width: 59pt;" width="79"> <col style="width: 68pt;" width="91"> <col style="width: 50pt;" width="66"> <col style="width: 48pt;" width="64"> <col style="width: 44pt;" width="59"> <tbody><tr style="height: 15.75pt;" height="21"> <td colspan="2" class="xl76" style="height: 15.75pt; width: 157pt;" width="209" height="21">Sale Price per Apparel and Cost per apparel are two different tables and are separated. I need to find a formula that will help me find the unit cost(cost per apparel) by using details from both details. An example would be i need to find the unit cost of a GUCCI CREW SHIRT. The answer is $19.74. I used multiple index and match functions to try to find this but its not working out. Any ideas? Should i include Vlookup?
Sale price per apparel</td> <td style="width: 46pt;" width="61">
</td> <td style="width: 59pt;" width="79">
</td> <td style="width: 68pt;" width="91">
</td> <td colspan="3" class="xl76" style="width: 142pt;" width="189">
Cost per apparel</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl69" style="height: 15.75pt; border-top: medium none;" height="21">Merchandise</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> T</td> <td class="xl71" style="border-left: medium none;">CREW</td> <td class="xl72" style="border-left: medium none;">ZIP_UP</td> <td>
</td> <td class="xl68" style="border-top: medium none;">T</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">CREW</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">ZIP_UP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
PKT SQ</td> <td class="xl74" style="border-top: medium none;"> 36.88 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 43.81 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 30.21 </td> <td>
</td> <td class="xl66">12.65</td> <td class="xl66" style="border-left: medium none;">15.63</td> <td class="xl66" style="border-left: medium none;">11.87</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
TRUMPET</td> <td class="xl74" style="border-top: medium none;"> 30.94 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 39.51 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 40.80 </td> <td>
</td> <td class="xl66">14.86</td> <td class="xl66" style="border-left: medium none;">15.47</td> <td class="xl66" style="border-left: medium none;">15.32</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
GUCCI</td> <td class="xl74" style="border-top: medium none;"> 43.66 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 57.52 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 36.96 </td> <td>
</td> <td class="xl66">18.74</td> <td class="xl66" style="border-left: medium none;">19.74</td> <td class="xl66" style="border-left: medium none;">15.54</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
KINEY</td> <td class="xl74" style="border-top: medium none;"> 28.47 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 43.69 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 31.67 </td> <td>
</td> <td class="xl66">12.65</td> <td class="xl66" style="border-left: medium none;">16.21</td> <td class="xl66" style="border-left: medium none;">12.76</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
DOPE N°5</td> <td class="xl74" style="border-top: medium none;"> 22.97 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 29.18 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 26.51 </td> <td>
</td> <td class="xl66">10.86</td> <td class="xl66" style="border-left: medium none;">9.78</td> <td class="xl66" style="border-left: medium none;">9.43</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
SOHO</td> <td class="xl74" style="border-top: medium none;"> 48.49 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 36.46 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 32.22 </td> <td>
</td> <td class="xl66">16.43</td> <td class="xl66" style="border-left: medium none;">12.54</td> <td class="xl66" style="border-left: medium none;">13.64</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl70" style="height: 15.75pt;" height="21">
VELO</td> <td class="xl74" style="border-top: medium none;"> 33.90 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 36.06 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 42.26 </td> <td>
</td> <td class="xl67">12.78</td> <td class="xl67" style="border-left: medium none;">16.54</td> <td class="xl67" style="border-left: medium none;">18.74
</td> </tr> </tbody></table>
Sale price per apparel</td> <td style="width: 46pt;" width="61">
</td> <td style="width: 59pt;" width="79">
</td> <td style="width: 68pt;" width="91">
</td> <td colspan="3" class="xl76" style="width: 142pt;" width="189">
Cost per apparel</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl69" style="height: 15.75pt; border-top: medium none;" height="21">Merchandise</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> T</td> <td class="xl71" style="border-left: medium none;">CREW</td> <td class="xl72" style="border-left: medium none;">ZIP_UP</td> <td>
</td> <td class="xl68" style="border-top: medium none;">T</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">CREW</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">ZIP_UP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
PKT SQ</td> <td class="xl74" style="border-top: medium none;"> 36.88 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 43.81 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 30.21 </td> <td>
</td> <td class="xl66">12.65</td> <td class="xl66" style="border-left: medium none;">15.63</td> <td class="xl66" style="border-left: medium none;">11.87</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
TRUMPET</td> <td class="xl74" style="border-top: medium none;"> 30.94 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 39.51 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 40.80 </td> <td>
</td> <td class="xl66">14.86</td> <td class="xl66" style="border-left: medium none;">15.47</td> <td class="xl66" style="border-left: medium none;">15.32</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
GUCCI</td> <td class="xl74" style="border-top: medium none;"> 43.66 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 57.52 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 36.96 </td> <td>
</td> <td class="xl66">18.74</td> <td class="xl66" style="border-left: medium none;">19.74</td> <td class="xl66" style="border-left: medium none;">15.54</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
KINEY</td> <td class="xl74" style="border-top: medium none;"> 28.47 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 43.69 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 31.67 </td> <td>
</td> <td class="xl66">12.65</td> <td class="xl66" style="border-left: medium none;">16.21</td> <td class="xl66" style="border-left: medium none;">12.76</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
DOPE N°5</td> <td class="xl74" style="border-top: medium none;"> 22.97 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 29.18 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 26.51 </td> <td>
</td> <td class="xl66">10.86</td> <td class="xl66" style="border-left: medium none;">9.78</td> <td class="xl66" style="border-left: medium none;">9.43</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">
SOHO</td> <td class="xl74" style="border-top: medium none;"> 48.49 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 36.46 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 32.22 </td> <td>
</td> <td class="xl66">16.43</td> <td class="xl66" style="border-left: medium none;">12.54</td> <td class="xl66" style="border-left: medium none;">13.64</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl70" style="height: 15.75pt;" height="21">
VELO</td> <td class="xl74" style="border-top: medium none;"> 33.90 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 36.06 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> 42.26 </td> <td>
</td> <td class="xl67">12.78</td> <td class="xl67" style="border-left: medium none;">16.54</td> <td class="xl67" style="border-left: medium none;">18.74
</td> </tr> </tbody></table>