Spreadsheet: 274653d1383171474-function-vlookup-but-need-index-match-index-matcherror
Sheet: EbayActive  (2)

EbA1:U41ay Item | Products | Unit Cost | VAT Code | VAT 20% | Total per Unit | Total Price | Total VAT | Units Sold | Stock Numbers | Remaining Stock | Ebay Price | [NAME] | [NAME] | [NAME] | Ebay Final Price | Paypal | Weight | [NAME] | Postage | Carrier | Express | Carrier2 | Total Cost | Profit | Total if Sold |  |  |  |  |  | Vat Code | VAT Rate
190920375481 | Panasonic DMP-BDT230EB | 84.99 | 2 |  |  |  |  |  | 2 |  | 134.97 |  | Technology | 0.4 | 6.75 | 4.79 | 1.9 | 470*270*80 | 6.4 | Hermmes | 10.18 | Interparcel |  |  |  |  |  |  |  |  | 2 | 0.2
190919489986 | PanasonicWireless Speaker SC-NE3EBK | 139.99 | 2 |  |  |  |  | 1 | 2 |  | 209.97 |  | Technology | 0.4 | 10.5 | 7.34 | 3.2 | 630*260*180 | 8.8 | Hermmes | 10.18 | Interparcel |  |  |  |  |  |  |  |  | 3 | 0.1514
190920377981 | LG Music in Style ND4520 | 79.97 | 2 |  |  |  |  |  | 2 |  | 129.97 |  | Technology | 0.4 | 6.5 | 4.62 | 2.6 | 460*210*150 | 6.4 | Hermmes | 10.18 | Interparcel |  |  |  |  |  |  |  |  | 1 | 0
190921042796 | Bosu | 64.99 | 2 |  |  |  |  |  | 1 |  | 112.97 |  | Basic | 0.3 | 11.3 | 4.04 |  |  | 9.4 | Hermmes | 10.18 | Interparcel
190899026594 | [NAME] | 21.96 | 2 |  |  |  |  | 2 | 2 |  | 45.97 |  | Basic | 0.3 | 4.6 | 1.76 |  |  | 6.4 | Hermmes
190926397056 | Shedrain Umbrella Set | 9.97 | 2 |  |  |  |  | 4 | 8 |  | 25.97 |  | Clothing, Shoes & Accessories | 0.3 | 2.86 | 1.08 | 0.885 | 355*120*65 | 3.7 | Royal Mail
190926608556 | Optoma HD131X Full 3D 1080p Projector | 524.91 | 2 |  |  |  |  | 1 | 10 |  | 724.97 |  | Technology | 0.3 | 10 | 27.75 |  |  | 0 | Costco | 0 | Costco
190935260533 | Sony Headphones | 8.32 | 2 |  |  |  |  | 4 | 30 |  | 15.97 |  | Technology | 0.3 | 0.8 | 0.74 |  |  | 0 | Amazon | 0 | Amazon
190935258851 | Wedgewood Silver Frames | 19.97 | 2 |  |  |  |  |  | 2 |  | 62.97 |  | Basic | 0.3 | 6.3 | 2.34 | 0.985 | 290*250*55 | 3.7 | Royal Mail
190935259009 | Vera Wang | 19.97 | 2 |  |  |  |  |  | 2 |  | 44.97 |  | Basic | 0.3 | 4.5 | 1.73 | 1.6 | 250*250*55 | 3.7 | Royal Mail
190935371587 | Swann DVK8-3000 | 391.66 | 2 |  |  |  |  |  | 6 |  | 699.97 |  | Technology | 0.6 | 10 | 24 |  |  | 0 | Costco | 0 | Costco
190935365470 | FEIT LED Flashlights | 19.99 | 2 |  |  |  |  |  | 4 |  | 41.97 |  | Furniture | 0.3 | 3.9 | 1.63 | 0.9 | 270*270*60 | 3.7 | Royal Mail | 8.25 | Royal Mail
190935739759 | MagLite LED | 19.97 | 2 |  |  |  |  |  | 4 |  | 43.97 |  | Furniture | 0.3 | 4.4 | 1.69 | 1.2 | 460*240*80 | 5.2 | Hermmes | 10.18 | Interparcel
190935764535 | LegoCargo | 39.99 | 2 |  |  |  |  |  | 2 |  | 78.97 |  | Toys | 0.3 | 7.9 | 2.88 | 1.8 | 480*380*90 | 5.2 | Hermmes | 10.8 | Interparcel
190935963351 | [NAME] I-Stubble | 29.97 | 2 |  |  |  |  |  | 2 |  | 54.97 |  | Basic | 0.3 | 5.4 | 2.07 | 2.7 | 600*500*100 | 5.2 | Hermmes | 10.8 | Interparcel
190935964096 | PlayMobilPolice | 33.99 | 2 |  |  |  |  |  | 2 |  | 68.97 |  | Furniture | 0.3 | 6.9 | 2.54 | 0.5 | 280*175*120 | 6.4 | Hermmes | 10.8 | Interparcel
190936642197 | Womens garden gloves | 3.97 | 2 |  |  |  |  |  | 3 |  | 18.97 |  |  | 0.3 | 1.9 | 0.84 | 0.38 | 340*280*53 | 3.7 | Royal Mail | 8.25 | Royal Mail
190950544750 | [NAME] | 6.49 | 2 |  |  |  |  |  | 2 |  | 22.96 |  |  | 0.3 | 2.3 | 0.98 | 3.2 | 390*375*125 | 6.4 | Hermmes | 10.8 | Interparcel
190937394967 | Scissors | 7.69 | 2 |  |  |  |  |  | 4 |  | 19.97 |  |  | 0.3 | 2 | 0.88 | 0.35 | 380*255*30 | 3.7 | Royal Mail | 8.25 | Royal Mail
190937394908 | Philips Shaver | 59.97 | 2 |  |  |  |  |  | 2 |  | 98.97 |  |  | 0.3 | 9.9 | 3.56 | 0.6 | 245*175*88 | 6.4 | Hermmes | 10.8 | Interparcel
190912076543 | [NAME] | 458.33 | 2 |  |  |  |  |  | 5 |  | 689.97 |  |  | 0.3 | 40 | 23.66 |  |  | 0 | Costco | 0 | Costco
190941979374 | iPhone 4s | 141.66 | 2 |  |  |  |  |  | 1 |  | 370 |  |  | 0.3 | 10 | 12.78 | 380 | 130*80*70 | 6.95 | Royal Mail | 9.99 | Royal Mail
190921002686 | [NAME] | 124.99 | 2 |  |  |  |  |  | 2 |  | 186.97 | 9.99 | Furniture | 0.3 | 19.7 | 6.9 | 5.8 | 460*390*280 | 10.6 | Hermmes | 15.59 | Interparcel
190925468238 | [NAME] | 21.96 | 2 |  |  |  |  | 1 | 6 |  | 45.97 |  | Basic | 0.3 | 4.6 | 1.76 |  |  | 6.4 | Hermmes
190945124407 | [NAME]" | 19.99 | 2 |  |  |  |  |  | 2 |  | 41.97 |  | Collectable | 0.3 | 3.78 | 1.63 | 2.5 | 830*330*155 | 5.4 | Hermmes | 11.99 | Interparcel
190945154610 | [NAME] | 19.99 | 2 |  |  |  |  |  | 1 |  | 39.97 |  | Basic | 0.3 | 4 | 1.56 | 0.6 | 490*185*95 | 4.2 | Hermmes | 11.99 | Interparcel
190945211040 | Swizzels Matlow Party Pack | 12.74 | 2 |  |  |  |  |  | 1 |  | 31.97 |  | Furniture | 0.3 | 3.2 | 1.29 | 5 | 290*220*260 | 5.4 | Hermmes | 11.99 | Interparcel
190946529887 | Amaretti Tin | 5.49 | 1 |  |  |  |  |  | 4 |  | 16.97 |  | Furniture | 0.3 | 1.7 | 0.78 | 0.76 | 260*140*140 | 4.2 | Hermmes | 11.99 | Interparcel
190945258994 | [NAME] | 15.99 | 3 |  |  |  |  |  | 2 |  | 32.97 |  | Furniture | 0.3 | 3.3 | 1.32 | 1.53 | 380*230*15 | 4.2 | Hermmes | 11.99 | Interparcel
190946569687 | Tin Ginger Nuts | 3.99 | 1 |  |  |  |  |  | 2 |  | 16.97 |  | Furniture | 0.3 | 1.7 | 0.78 | 1.2 | 140*85*85 | 4.2 | Hermmes | 11.99 | Interparcel
190946616790 | [NAME] | 9.99 | 2 |  |  |  |  |  | 4 |  | 23.97 |  | Furniture | 0.3 | 2.4 | 1.01 | 0.58 | 235*198*138 | 4.2 | Hermmes | 11.99 | Interparcel
190946742064 | LED Candles | 19.99 | 2 |  |  |  |  |  | 1 |  | 38.97 |  | Furniture | 0.3 | 3.9 | 1.52 | 1.92 | 590*190*90 | 4.2 | Hermmes | 11.99 | Interparcel
190946834513 | Wells Leather Glover | 14.99 | 2 |  |  |  |  |  | 3 |  | 29.97 |  | Basic | 0.3 | 3 | 1.22 | 0.7 | 330*330*50 | 3.7 | Royal Mail | 11.99 | Interparcel
190946834513 | Wells Leather Glover | 5 | 2 |  |  |  |  |  | 9 |  | 14.97 |  | Basic | 0.3 | 1.5 | 0.71 | 0.2 | 125*130*25 | 2.2 | Royal Mail | 9.99 | Royal Mail
190948249688 | RC Robotic UFO | 14.99 | 2 |  |  |  |  |  | 2 |  | 28.97 |  | Furniture | 0.3 | 2.9 | 1.18 | 0.64 | 250*230*230 | 4.2 | Hermmes | 11.99 | Interparcel
190948300292 | Shedrain Umbrella Pattern | 7.49 | 2 |  |  |  |  |  | 4 |  | 19.97 |  | Clothing, Shoes & Accessories | 0.3 | 2.2 | 0.88 | 0.46 | 350*95*60 | 3.7 | Royal Mail | 11.99 | Interparcel
190949349015 | Lazz Pandora Cake | 5.99 | 1 |  |  |  |  |  | 2 |  | 16.97 |  | Furniture | 0.3 | 1.7 | 0.78 | 1.5 | 220*220*220 | 4.2 | Hermmes | 11.99 | Interparcel
190949458638 | Gas [NAME] x 6 | 14.29 | 2 |  |  |  |  |  | 1 |  | 31.97 |  | Basic | 0.3 | 3.2 | 1.29 | 2.5 | 210*220*140 | 5.4 | Hermmes | 11.99 | Interparcel
190949600253 | Post it Notes 24 Pack | 9.99 | 2 |  |  |  |  |  | 2 |  | 26.49 |  | Basic | 0.3 | 2.65 | 1.1 | 1.03 | 230*80*76 | 4.2 | Hermmes | 11.99 | Interparcel
 | Golf Umbrellas  Sets | 11.97 | 2 |  |  |  |  |  | 2 |  | 29.97 |  | Basic | 0.3 | 3 | 1.22 | 1.8 | 1100*1656*50 | 4.2 | Hermmes | 11.99 | Interparcel
 | WD40  3 x 400 ml Set | 6.99 | 2 |  |  |  |  |  | 1 |  | 19.97 |  | Basic | 0.3 | 2 | 0.88 | 1.4 | 200*200*70 | 4.2 | Hermmes | 11.99 | Interparcel
 | Candle lamp | 6.73 | 2 |  |  |  |  |  | 1 |  | 17.97 |  | Furniture | 0.3 | 1.8 | 0.81 | 0.24 | 200*140*35 | 3.7 | Royal Mail | 6.99 | Interparcel
 |  | 10.38 | 2
 |  |  | 2