Spreadsheet: 92385d1291950337-multple-if-conditions-matching-data-in-a-table-purchase-order-lookup-formula-example-workbook
Sheet: Working Orders

Order | Name | Vendor | Sku | Quantity | PO Number | Date | Working
1314836 | The Western Guide to [NAME] for Romance | Pea | [NAME] | 1 | poPea091210 | 091210 | po
1314836 | The Psychology of Love by [NAME] | Pea | /[PHONE] | 1 | poPea091210 | 091210 | po
1314872 | Bodum Barcelona Stainless Steel Cutlery Set | She | 27670 | 2 | poShe091210 | 091210 | po
35037 | Sennheiser RS 120 Wireless Headphones | Syn | RS 120-9 | 1 | poSyn091210 | 091210 | po
35085 | Complete Idiot's Guide to the Anti-Inflammation Diet by Christopher P Cannon & [NAME] | Pea | /[PHONE] | 1 | poPea091210 | 091210 | po
35085 | How To Become a Kitchen Table Millionaire: Grow Your Idea into a by Catriona MacLennan | Pea | /[PHONE] | 1 | poPea091210 | 091210 | po
35112 | Sennheiser RS 110 Wireless Headphones | Syn | RS 110-9 | 1 | poSyn091210 | 091210 | po
35124 | RHS Vegetables in a Small Garden: Simple Steps to Success | Pea | /[PHONE] | 1 | poPea091210 | 091210 | po
35202 | When Your Child Is Ill: A Home Guide for Parents by [NAME] | Pea | /[PHONE] | 1 | poPea091210 | 091210 | po
35202 | Complete Baby & Childcare: Everything You Need to Know for the First Five Years. by [NAME] | Pea | /[PHONE] | 1 | poPea091210 | 091210 | po
Nicole | Moppel by LED [NAME], Pen Holder, [NAME] | Zen | ZL9851 | 1 | poZen091210 | 091210 | po
35259 | Santoys Portable Cooker With Accessories | Edu | 157495 | 1 | poEdu091210 | 091210 | po
35265 | Step 2 Up And [NAME] Coaster | Edu | 157917 | 1 | poEdu091210 | 091210 | po
35271 | [NAME] In My Room | Glo | 2056UM | 1 | poGlo091210 | 091210 | po
35274 | Luigi Bormioli Michelangelo Dinner Set - 16 Piece | Mac | MA16DS | 1 | poMac091210 | 091210 | po
35277 | Ocho Milan Picnic [NAME] | Och | [NAME] | 1 | poOch091210 | 091210 | po
35280 | Bodum Chambord Coffee Maker with Bonus Pavina Glasses | She | 27022BP | 1 | poShe091210 | 091210 | po
35286 | Twenty-Five Years of Australian Geographic Photography H/C | Woo | 9781921683336 | 1 | poWoo091210 | 091210 | po
35286 | [NAME] Best! 2011 Edition | Woo | 9780980774900 | 1 | poWoo091210 | 091210 | po
35292 | [NAME] (Navy) | Och | ochobkn | 1 | poOch091210 | 091210 | po
35292 | [NAME] (Black) | Och | ochobkb | 1 | poOch091210 | 091210 | po
35295 | [NAME] 24 Piece - 6 Person | Mac | 50183 | 4 | poMac091210 | 091210 | po
35298 | Quercetti [NAME] | Edu | 217851 | 1 | poEdu091210 | 091210 | po
35301 | Twenty-Five Years of Australian Geographic Photography H/C | Woo | 9781921683336 | 1 | poWoo091210 | 091210 | po
35304 | Homedics Neck and [NAME] with Heat | Hom | NMSQ-200 | 1 | poHom091210 | 091210 | po
35304 | [NAME] | Glo | 2016 | 1 | poGlo091210 | 091210 | po
35304 | [NAME] Flavour Shaker Charcoal | Mac | J11000EAX | 1 | poMac091210 | 091210 | po
35304 | Heat Factory Mini Warmer Box - Contains 40 pairs | Zen | XH1953 | 1 | poZen091210 | 091210 | po
35307 | Step 2 Easel For Two | Edu | 157776 | 1 | poEdu091210 | 091210 | po
35310 | [NAME] with Sheath (Leather) | Zen | YL 207L | 1 | poZen091210 | 091210 | po
35313 | [NAME] | Glo | 2016 | 1 | poGlo091210 | 091210 | po
35316 | Luigi Bormioli Bacio Dof - Set of 4 | Mac | 6508406B | 1 | poMac091210 | 091210 | po
35316 | The World Crisis 1911-1918 by [NAME] | Pea | /[PHONE] | 1 | poPea091210 | 091210 | po
35319 | LED [NAME] | Zen | ZL8407 | 2 | poZen091210 | 091210 | po
35325 | Ocho Milan Picnic [NAME] | Och | [NAME] | 2 | poOch091210 | 091210 | po
35331 | Bodum Chambord Coffee Maker with Bonus Pavina Glasses | She | 27022BP | 1 | poShe091210 | 091210 | po
35334 | Bodum Chambord Coffee Maker with Bonus Pavina Glasses | She | 27022BP | 1 | poShe091210 | 091210 | po
35337 | Homedics Delux Shiatsu One Massaging Cushion | Hom | SBM-600H-AU | 1 | poHom091210 | 091210 | po
35340 | Homedics Neck and [NAME] with Heat | Hom | NMSQ-200 | 1 | poHom091210 | 091210 | po
35349 | Homedics Neck and [NAME] with Heat | Hom | NMSQ-200 | 1 | poHom091210 | 091210 | po
35352 | Mamas & Papas - Famiglia Silky Fur Traditional Jointed Bear | Chi | M757065001 | 1 | poChi091210 | 091210 | po
35355 | Bodum Chambord Coffee Maker with Bonus Pavina Glasses | She | 27022BP | 1 | poShe091210 | 091210 | po
35358 | Mamas & Papas - Famiglia Silky Fur Traditional Jointed Bear | Chi | M757065001 | 1 | poChi091210 | 091210 | po
35361 | Ocho Sintra Picnic [NAME] | Och | euro7 | 1 | poOch091210 | 091210 | po
35364 | Make the Most of Your Time on Earth: A Rough Guide to the World | Pea | /[PHONE] | 1 | poPea091210 | 091210 | po
35364 | [NAME] | Vwho | 63756731a. | 1 | poVwho091210 | 091210 | po
35364 | [NAME] | Mac | 49026 | 1 | poMac091210 | 091210 | po
35364 | [NAME] | Mac | barbkit | 1 | poMac091210 | 091210 | po
35367 | [NAME] 10 piece Tool Case | Mac | BARCASEC | 1 | poMac091210 | 091210 | po
35373 | Mamas & Papas Baby Play Deluxe Light and Sound Play Mat and Gym | Chi | M759482702 | 1 | poChi091210 | 091210 | po
35379 | Nite [NAME] for [NAME]'s - Various Colours (Green) | Zen | XNSKL0328 | 2 | poZen091210 | 091210 | po
35385 | Bodum Chambord Coffee Maker with Bonus Pavina Glasses | She | 27022BP | 1 | poShe091210 | 091210 | po
35388 | Moppel by LED [NAME], Pen Holder, [NAME] | Zen | ZL9851 | 2 | poZen091210 | 091210 | po
35394 | Ocho Milan Picnic [NAME] | Och | [NAME] | 1 | poOch091210 | 091210 | po
35397 | [NAME] | Glo | 2016 | 1 | poGlo091210 | 091210 | po
35397 | Mamas & Papas - Babyplay 123 Lotty Ladybird | Chi | M755882708 | 1 | poChi091210 | 091210 | po
35400 | Homedics Neck and [NAME] with Heat | Hom | NMSQ-200 | 2 | poHom091210 | 091210 | po
35403 | Australian Bush Pubs | Woo | /[PHONE] | 1 | poWoo091210 | 091210 | po
35406 | Panasonic Clock radio with iPod Dock | Pan | RC-DC1 | 1 | poPan091210 | 091210 | po
35409 | Homedics Neck and [NAME] with Heat | Hom | NMSQ-200 | 1 | poHom091210 | 091210 | po
35412 | Bundle Special - Sydney's [NAME], Park & City Walks + Sydney's Best Harbour & Coastal Walks | Woo | /[PHONE][PHONE] | 1 | poWoo091210 | 091210 | po
35415 | Sennheiser RS 180 Wireless Headphones | Syn | RS 180 | 2 | poSyn091210 | 091210 | po
35421 | Bodum Canteen Double Wall Glass - Various Sizes (Large) | She | LRG27432 | 2 | poShe091210 | 091210 | po
35427 | Ocho Milan Picnic [NAME] | Och | [NAME] | 1 | poOch091210 | 091210 | po
35427 | [NAME] Grill Set with 6 Steak Knvies | Mac | barbgrill | 1 | poMac091210 | 091210 | po
35430 | [NAME] (Black) | Och | R1d | 2 | poOch091210 | 091210 | po
35433 | [NAME] Bag | Och | #26 | 1 | poOch091210 | 091210 | po
35436 | Panasonic ES4029 Men's Rechargeable Electric Shaver | Pan | ES4029 | 1 | poPan091210 | 091210 | po
35439 | [NAME] | Zen | XCJC1000 | 1 | poZen091210 | 091210 | po
1314944 | [NAME] | Glo | 2016 | 1 | poGlo091210 | 091210 | po
1314950 | [NAME] | Zen | YL 113N | 2 | poZen091210 | 091210 | po
1314950 | [NAME] Torch - YLFM400 | Zen | YLFM400 | 1 | poZen091210 | 091210 | po
1314953 | Leatherman Monarch 300 Torch - YL FM300 | Zen | YL FM300 | 3 | poZen091210 | 091210 | po
1314959 | Nite Ize L.E.D Dog Ball - K9- Various Colours (Blue) | Zen | XNMTLP0803 | 1 | poZen091210 | 091210 | po
1314962 | [NAME] Piece - 8 Person | Mac | 50186 | 1 | poMac091210 | 091210 | po
1314965 | [NAME] to [NAME] | Woo | 9780646528823 | 1 | poWoo091210 | 091210 | po
1314965 | Leatherman Black Wave with Nylon Sheath | Zen | YL 205BKN | 1 | poZen091210 | 091210 | po
1314968 | Educo Fun Farm Magnetic Marble Maze | Edu | 270587 | 1 | poEdu091210 | 091210 | po
1314974 | Ocho Milan Picnic Tote Bag & Rug | Och | Euro6/R1b | 1 | poOch091210 | 091210 | po
1314977 | [NAME] ? Pretty Pink | Och | euro92 | 1 | poOch091210 | 091210 | po
1314983 | Radio [NAME] Dual Deck Tricycle - Various Colours (Red) | Glo | 33 RF | 1 | poGlo091210 | 091210 | po
1314986 | Bodum Canteen Double Wall Glass - Various Sizes (Medium) | She | 27431 | 1 | poShe091210 | 091210 | po
1314986 | [NAME] 270ml - Essence of Vanilla | Och | MVL_VAN270 | 1 | poOch091210 | 091210 | po
1314989 | [NAME] with Sheath (Leather) | Zen | YL 209L | 1 | poZen091210 | 091210 | po
1314992 | Nite Ize [NAME] (RedLarge) | Zen | XNNND0310L | 1 | poZen091210 | 091210 | po
1314995 | Grosvenor Boston 40 Piece Cutlery Set | Mac | 50204 | 1 | poMac091210 | 091210 | po
1314998 | Twenty-Five Years of Australian Geographic Photography H/C | Woo | 9781921683336 | 1 | poWoo091210 | 091210 | po
1315001 | [NAME] In My Room | Glo | 2056UM | 1 | poGlo091210 | 091210 | po
1315004 | [NAME] | Glo | 2016 | 1 | poGlo091210 | 091210 | po
1315010 | Homedics Neck and [NAME] with Heat | Hom | NMSQ-200 | 1 | poHom091210 | 091210 | po
1315013 | Homedics Neck and [NAME] with Heat | Hom | NMSQ-200 | 1 | poHom091210 | 091210 | po
1315022 | Homedics Neck and [NAME] with Heat | Hom | NMSQ-200 | 1 | poHom091210 | 091210 | po
1315025 | Homedics Neck and [NAME] with Heat | Hom | NMSQ-200 | 1 | poHom091210 | 091210 | po
1315028 | Nite [NAME] for [NAME]'s - Various Colours (Red) | Zen | XNSKL0310 | 1 | poZen091210 | 091210 | po
1315031 | Leatherman Charge ALX Aircraft Aluminium Scale with Sheath (Leather) | Zen | YL 194L | 1 | poZen091210 | 091210 | po
1315037 | [NAME] Piece - 8 Person | Mac | 50186 | 1 | poMac091210 | 091210 | po
1315043 | Bundle Special - Sydney's [NAME], Park & City Walks + Sydney's Best Harbour & Coastal Walks | Woo | /[PHONE][PHONE] | 1 | poWoo091210 | 091210 | po
1315052 | Australian Bush Cooking 3/e | Woo | /[PHONE] | 1 | poWoo091210 | 091210 | po
1315058 | [NAME] | Mac | 49026 | 1 | poMac091210 | 091210 | po
1315067 | Nite [NAME] for [NAME]'s - Various Colours (Blue) | Zen | XNSKL0303 | 2 | poZen091210 | 091210 | po
1315067 | Nite [NAME] for [NAME]'s - Various Colours (Red) | Zen | XNSKL0310 | 2 | poZen091210 | 091210 | po
1315073 | Radio [NAME] First Scooter - Pink | Glo | 540G RF | 1 | poGlo091210 | 091210 | po