Spreadsheet: 745330d1629860374-using-vlookup-across-two-sheets-with-multiple-matches-book4
Sheet: Sheet2

STYLE NO | NAME | COLOUR | SIZE | Wholesale (excl GST) | RRP (incl GST) | RRP (excl GST) | Consignment | Internet | Corp Special
3963 | Crosshaven | 03 Navy | 38-48 | 383.95 | 699.95 | 636.3181818181818 | 403.1475 | 412.74625 | 479.9375
3857 | Ultima | 01 Black, 02 [NAME], 32 NAVY/BROWN | 35-48 | 328.95 | 599.95 | 545.4090909090909 | 345.3975 | 353.62125 | 411.1875
3859 | Ultima Extra Fit | 01 Black, 02 [NAME], 32 NAVY/BROWN | 35-48 | 328.95 | 599.95 | 545.4090909090909 | 345.3975 | 353.62125 | 411.1875
3733 | Shamrock | 32 Navy/Brown | 36-48 | 290.95 | 529.95 | 481.7727272727273 | 305.4975 | 312.77125 | 363.6875
3745 | Shamrock ExtraFit | 32 Navy/Brown | 37-48 | 290.95 | 529.95 | 481.7727272727273 | 305.4975 | 312.77125 | 363.6875
3750 | Fastnet | Carbon | 35-48 | 219.95 | 399.95 | 363.5909090909091 | 230.9475 | 236.44625 | 274.9375
3723 | Commodore X LT | 03 Navy, [NAME], 15 Old Rum, 22 MAHOGANY, 32 Navy/Brown,                     95 Chestnut | 40-47 | 165.95 | 359.95 | 327.2272727272727 | 174.2475 | 178.39625 | 207.4375
3722 | Sailmaker X LT | 03 Navy,15 [NAME], 19 Whiskey, 22 MAHOGANY, 32 Navy/Brown,               95 Chestnut | 40-47 | 160.95 | 349.95 | 318.1363636363636 | 168.9975 | 173.02125 | 201.1875
3831 | Portofino | 00 White, 02 Brown, 03 Navy, 63 [NAME] | tbc | 137.95 | 299.95 | 272.6818181818181 | 144.8475 | 148.29625 | 172.4375
3747 | Armada X LT | 02 Brown, 03 Navy, 39 [NAME], 52 Walnut, 63 [NAME] | 40-47 | 160.95 | 349.95 | 318.1363636363636 | 168.9975 | 173.02125 | 201.1875
3968 | Atlantic | 03 Navy, 15 Old Rum,  34 Navy/Mahogany, 95 Chestnut | 40-47 | 160.95 | 349.95 | 318.1363636363636 | 168.9975 | 173.02125 | 201.1875
3869 | Regatta | 02 Brown, 03 Navy, 15 Old Rum, 32 Navy/Brown, 88 [NAME],   95 Chestnut | 37-48 | 149.95 | 299.95 | 272.6818181818181 | 157.4475 | 161.19625 | 187.4375
3878 | Regatta Extra Fit | 03 Navy, 88 Donkey Brown | 40-48 | 149.95 | 299.95 | 272.6818181818181 | 157.4475 | 161.19625 | 187.4375
3868 | Yacht | 02 Brown, 03 Navy, 88 [NAME], 95 Chestnut | 40-48 | 149.95 | 299.95 | 272.6818181818181 | 157.4475 | 161.19625 | 187.4375
3735 | Port | 02 Brown, 03 Navy, 04 Taupe, 15 Old Rum, 18 Café, 61 Russet, 63 [NAME], 66 Oyster | 39-47 | 123.95 | 269.95 | 245.4090909090909 | 130.1475 | 133.24625 | 154.9375
3736 | Spinnaker | 02 Brown, 03 Navy | 39-47 | 123.95 | 269.95 | 245.4090909090909 | 130.1475 | 133.24625 | 154.9375
3331 | Admirals | 02 Brown, 03 Navy, 34 Navy/Brown | 3-11,12,13 | 114.95 | 249.95 | 227.2272727272727 | 120.6975 | 123.57125 | 143.6875
3752 | Tobago | 43 French Navy,  62 Cigar | 41-47 | 137.95 | 299.95 | 272.6818181818181 | 144.8475 | 148.29625 | 172.4375
3749 | [NAME] | navy | 40-48 | 151.95 | 329.95 | 299.9545454545454 | 159.5475 | 163.34625 | 189.9375
3829 | Antibes | platinum | 35-49 | 110.95 | 239.95 | 218.1363636363636 | 116.4975 | 119.27125 | 138.6875
3830 | [NAME] | Graphite , navy | 35-49 | 110.95 | 239.95 | 218.1363636363636 | 116.4975 | 119.27125 | 138.6875
3739 | Aruba | 14 Coral, 18 Café, 20 [NAME], 63 Denim, 73 Denim/Tan | 36-42 | 114.95 | 249.95 | 227.2272727272727 | 120.6975 | 123.57125 | 143.6875
3740 | Belize | 14 Coral, 18 Café, 20 [NAME],  22 Mahogany, 53 Denim/Red, 55 Caramel, 63 [NAME] | 36-42 | 114.95 | 249.95 | 227.2272727272727 | 120.6975 | 123.57125 | 143.6875
3759 | Florida | 27 Café/Carmel, 53 Denim/Red, 73 Denim/Tan | 36-42 | 137.95 | 299.95 | 272.6818181818181 | 144.8475 | 148.29625 | 172.4375
3760 | Havana | 27 Café/Carmel, 53 Denim/Red, 73 Denim/Tan | 36-42 | 137.95 | 299.95 | 272.6818181818181 | 144.8475 | 148.29625 | 172.4375
3741 | Jamaica | 03 Navy, [NAME],  29  [NAME] white, 33 [NAME] | 36-42 | 137.95 | 299.95 | 272.6818181818181 | 144.8475 | 148.29625 | 172.4375
3742 | Bali | 03 Navy, [NAME],  14 Coral | 36-42 | 137.95 | 299.95 | 272.6818181818181 | 144.8475 | 148.29625 | 172.4375
3885 | Galway | 01 Black, 02 [NAME], 32 Navy/Brown, 12 Black/Brown, 52 Walnut  , 79 Ivy | 35-48 | 331.95 | 649.95 | 590.8636363636364 | 348.5475 | 356.84625 | 414.9375
3931 | Galway Extra Fit | 12 Black/Brown, 32 Navy/Brown*, 52 Walnut | 35-48             *35-43 | 331.95 | 649.95 | 590.8636363636364 | 348.5475 | 356.84625 | 414.9375
3934 | [NAME] | 12 Black/Brown, /32 Navy/Brown*, 52 Walnut | 35-45             *35-43 | 331.95 | 649.95 | 590.8636363636364 | 348.5475 | 356.84625 | 414.9375
3948 | Sligo | 12 Black/Brown, 52 Walnut, 50 [NAME] | 36-42 | 357.95 | 699.95 | 636.3181818181818 | 375.8475 | 384.79625 | 447.4375
3989 | Longford | 01 Black, 12 Black/Brown, 52 Walnut | 35-43 | 357.95 | 699.95 | 636.3181818181818 | 375.8475 | 384.79625 | 447.4375
3944 | Glanmire | 02 Brown, 12 Black/Brown, 52 Walnut | 35-43 | 357.95 | 699.95 | 636.3181818181818 | 375.8475 | 384.79625 | 447.4375
3892 | Kildare | 01 Black,  02 [NAME], 12 Black/Brown, 32 Navy/Brown, 52 Walnut, 79 Ivy | 35-48 | 296.95 | 579.95 | 527.2272727272727 | 311.7975 | 319.22125 | 371.1875
3955 | Clare | 01 Black,  52 Walnut | 36-42 | 357.95 | 699.95 | 636.3181818181818 | 375.8475 | 384.79625 | 447.4375
3914 | Wexford | *50 [NAME], 52 Walnut, 79 Ivy* | 37-47        *41-47 | 434.95 | 849.95 | 772.6818181818181 | 456.6975 | 467.57125 | 543.6875
3986 | [NAME] | 01 Black, 15 Old Rum, 22 Mahogany, 52 Walnut,  95 Chestnut, | 40-48 | 270.95 | 529.95 | 481.7727272727273 | 284.4975 | 291.27125 | 338.6875
3986 | [NAME] | 62 Cigar, 64 Camel | 40-48 | 270.95 | 529.95 | 481.7727272727273 | 284.4975 | 291.27125 | 338.6875
3762 | [NAME] | 15 Old Rum | 35-43 | 291.95 | 569.95 | 518.1363636363636 | 306.5475 | 313.84625 | 364.9375
3762 | Downpatrick S | 62 Cigar, 64 Camel, 93 Black Suede | 35-43 | 270.95 | 529.95 | 481.7727272727273 | 284.4975 | 291.27125 | 338.6875
3946 | [NAME] | 01 Black, 15 Old Rum,  95 Chestnut | 35-43 | 270.95 | 529.95 | 481.7727272727273 | 284.4975 | 291.27125 | 338.6875
3946 | [NAME] | 62 Cigar, 64 Camel | 35-43 | 250.95 | 489.95 | 445.4090909090909 | 263.4975 | 269.77125 | 313.6875
4001 | Rockpool | 03 Navy, 28 Kingfisher, 56 Cardinal | EU 34-44  UK 8-18 | 154.95 | 339.95 | 309.0454545454545 | 162.6975 | 166.57125 | 193.6875
4002 | [NAME] | 03 Navy, 28 [NAME] | EU 34-44  UK 8-18 | 168.95 | 369.95 | 336.3181818181818 | 177.3975 | 181.62125 | 211.1875
4003 | Emerald | 00 White Multi, 03 Navy, 28 Kingfisher, 71 Carbon | EU 34-44  UK 8-18 | 109.95 | 239.95 | 218.1363636363636 | 115.4475 | 118.19625 | 137.4375
4004 | [NAME] | 00 White Multi, 03 Navy, 28 Kingfisher, 71 Carbon | EU 34-44  UK 8-18 | 99.95 | 219.95 | 199.9545454545454 | 104.9475 | 107.44625 | 124.9375
4007 | Lavelle | 28 Kingfisher, 83 Navy Multi | EU 34-44  UK 8-18 | 86.95 | 189.95 | 172.6818181818182 | 91.2975 | 93.47125 | 108.6875
4008 | Gregory | 03 Navy, 28 [NAME] | EU 34-44  UK 8-18 | 90.95 | 199.95 | 181.7727272727273 | 95.4975 | 97.77125000000001 | 113.6875
4009 | Barleycove | 00 White, 03 Navy, 28 Kingfisher, | EU 34-44  UK 8-18 | 90.95 | 199.95 | 181.7727272727273 | 95.4975 | 97.77125000000001 | 113.6875
4013 | Laragh | 03 Navy, 28 Kingfisher, 30 Platinum, 56 Cardinal | EU 34-44  UK 8-18 | 54.95 | 119.95 | 109.0454545454545 | 57.69750000000001 | 59.07125000000001 | 68.6875
4015 | Templehouse | 03 Navy, 24 Goldfinch, 30 Platinum, 56 Cardinal | EU 34-44  UK 8-18 | 63.95 | 139.95 | 127.2272727272727 | 67.14750000000001 | 68.74625 | 79.9375
4016 | Druid | 03 Navy, 56 Cardinal | EU 34-44  UK 8-18 | 72.95 | 159.95 | 145.4090909090909 | 76.5975 | 78.42125 | 91.1875
4018 | Riverview | 00 White, 03 Navy, 28 [NAME],  56 Cardinal | EU 34-44  UK 8-18 | 59.95 | 129.95 | 118.1363636363636 | 62.94750000000001 | 64.44625 | 74.9375
3453 | Daffodil | 00 White, 23 Pale Blue, 48 Pale Pink | EU 34-44  UK 8-18 | 72.95 | 159.95 | 145.4090909090909 | 76.5975 | 78.42125 | 91.1875
4124 | Chamomile | 00 White, 23 Pale Blue, 48 Pale Pink | EU 34-44  UK 8-18 | 68.95 | 149.95 | 136.3181818181818 | 72.39750000000001 | 74.12125 | 86.1875
4174 | Snowdrop | 00 White, 23 Pale Blue, 48 Pale Pink | EU 34-44  UK 8-18 | 68.95 | 149.95 | 136.3181818181818 | 72.39750000000001 | 74.12125 | 86.1875
4005 | Barrow | 03 Navy, 28 Kingfisher, 56 Cardinal | S-3XL | 168.95 | 369.95 | 336.3181818181818 | 177.3975 | 181.62125 | 211.1875
4006 | Liffey | 03 Navy, 28 Kingfisher, 70 CARBON | S-3XL | 136.95 | 299.95 | 272.6818181818181 | 143.7975 | 147.22125 | 171.1875
4011 | Rathwood | 03 Navy, 28 Kingfisher, 70 CARBON | S-3XL | 90.95 | 199.95 | 181.7727272727273 | 95.4975 | 97.77125000000001 | 113.6875
4019 | Harcourt | 03 NAVY, 57 IMPERIAL RED, 63 DENIM, 70 GRAPHITE | S-3XL | 68.95 | 149.95 | 136.3181818181818 | 72.39750000000001 | 74.12125 | 86.1875
4023 | [NAME] | 03 NAVY,  28 Goldfinch, 28 Kingfisher, 56 Cardinal | S-3XL | 63.95 | 139.95 | 127.2272727272727 | 67.14750000000001 | 68.74625 | 79.9375
4027 | Sandymount | 00 White Multi, 87 Blue Multi | S-3XL | 77.95 | 169.95 | 154.5 | 81.8475 | 83.79625 | 97.4375
4250 | [NAME] | 00 White, 23 Pale Blue | S-3XL | 90.95 | 199.95 | 181.7727272727273 | 95.4975 | 97.77125000000001 | 113.6875
3612 | Delphi | 03 Navy, 63 [NAME], 66 Oyster | 30-42 | 77.95 | 169.95 | 154.5 | 81.8475 | 83.79625 | 97.4375
4114 | Blackthorn | 03 Navy,   54 Woodrose, 58 Blue Heather,  69 [NAME], 89 [NAME], 97 Heath | EU 34-44  UK 8-18 | 505.95 | 999.95 | 909.0454545454545 | 531.2475 | 543.89625 | 632.4375
3511 | [NAME] | 03 Navy, 67 Elm,  86 Sorrel, 89 [NAME], 97 Heath | EU 34-44  UK 8-18 | 404.95 | 799.95 | 727.2272727272727 | 425.1975 | 435.32125 | 506.1875
3544 | Hazelwood | 03 Navy, 86 Sorrel, 54 Woodrose, 58 Blue Heather, 67 Elm, 89 Mist | One Size | 232.95 | 459.95 | 418.1363636363636 | 244.5975 | 250.42125 | 291.1875
4115 | [NAME] | 03 Navy, 54 Woodrose, 58 Blue Heather, 67 Elm, 86 Sorrel, 89 [NAME], 97 Heath | EU 34-44  UK 8-18 | 404.95 | 799.95 | 727.2272727272727 | 425.1975 | 435.32125 | 506.1875
3546 | [NAME] | 54 Woodrose,  67 Elm, 86 Sorrel,  89 Mist | EU 34-44  UK 8-18 | 232.95 | 459.95 | 418.1363636363636 | 244.5975 | 250.42125 | 291.1875
4162 | Fern | 03 Navy,  54 Woodrose,  58 Blue Heather, 69 Rowan,        86 Sorrel,  89 Mist | EU 34-44  UK 8-18 | 186.95 | 369.95 | 336.3181818181818 | 196.2975 | 200.97125 | 233.6875
3660 | Ballybrophy | 03 Navy, 09 Olive, 74 Smoke | EU 34-44  UK 8-18 | 249.95 | 549.95 | 499.9545454545454 | 262.4475 | 268.69625 | 312.4375
3276 | Spiddal | 09 Olive, 83 Navy Multi, 46 Amber, 96 Spruce | EU 34-44  UK 8-18 | 163.95 | 359.95 | 327.2272727272727 | 172.1475 | 176.24625 | 204.9375
3621 | [NAME] | 60 Woodbine, 76 [NAME] | 38-50 | 201.95 | 399.95 | 363.5909090909091 | 212.0475 | 217.09625 | 252.4375
3622 | Palmerstown | 01 Black, 03 Navy, 09 Olive | S-3XL | 312.95 | 679.95 | 618.1363636363636 | 328.5975 | 336.42125 | 391.1875
3472 | Carrickfergus | 03 Navy, 09 Olive, 49 Dusky Green,  50 [NAME] | S-3XL | 275.95 | 599.95 | 545.4090909090909 | 289.7475 | 296.64625 | 344.9375
3667 | Ballymote | 59 Black Watch | S-3XL | 321.95 | 699.95 | 636.3181818181818 | 338.0475 | 346.09625 | 402.4375
9456 | Dunlavin | 26 Orchid, 33 [NAME], 55 Carmel | OS | 214.95 | 469.95 | 427.2272727272727 | 225.6975 | 231.07125 | 268.6875
9766 | Dunbrody (5) | 01 Black, 32 Navy/Brown, 52 Walnut | OS | 86.95 | 189.95 | 172.6818181818182 | 91.2975 | 93.47125 | 108.6875
9781 | [NAME] (5) | 01 Black, 52 Walnut | OS | 68.95 | 149.95 | 136.3181818181818 | 72.39750000000001 | 74.12125 | 86.1875
9707 | Rugby (5) | 52 Walnut | OS | 54.95 | 119.95 | 109.0454545454545 | 57.69750000000001 | 59.07125000000001 | 68.6875
4133 | [NAME] | *03 Navy, *09 Olive, 10 Sky, 12 Cream, 14 Salmon, 25 Pink,  33 Mustard, 35 Malbec, 56 Cardinal, 67 Terracotta | 5 | 31.95 | 69.95 | 63.59090909090909 | 33.5475 | 34.34625 | 75.19625
5083 | Boot Liners | 01 Black, 57 Leopard, 60 lynx, 65 Elk, 80 [NAME] | 5 | 22.95 | 49.95 | 45.40909090909091 | 24.0975 | 24.67125 | 53.69625000000001
9877 | Gallagher | 03 Navy, 06 Sand, 09 Olive, 17 Bourbon |  | 72.95 | 159.95 | 145.4090909090909 | 76.5975 | 78.42125 | 171.94625
9787 | Tullynally | 68  Pheasant |  | 77.95 | 169.95 | 154.5 | 81.8475 | 83.79625 | 182.69625
9834 | Causeway | 03 Navy, 16 Stone, 58 Royal Blue | 5 | 18.95 | 39.95 | 36.31818181818182 | 19.8975 | 20.37125 | 42.94625000000001
9833 | Liscannor | 03 Navy, 05 Red, 06  Sand | 5 | 18.95 | 39.95 | 36.31818181818182 | 19.8975 | 20.37125 | 42.94625000000001
4134 | Holly | 03 Navy, 12 [NAME],  54 Woodrose, 58 Blue Heather, 67 Elm, 72 [NAME], 78 [NAME], 86 Sorrel, 89 [NAME], 97 Heath | 3 | 72.95 | 159.95 | 145.4090909090909 | 76.5975 | 78.42125 | 171.94625
9721 | Butler | 09 [NAME] |  | 131.95 | 289.95 | 263.5909090909091 | 138.5475 | 141.84625 | 311.69625
9843 | [NAME] | 83 Midnight, 60 Woodbine |  | 86.95 | 189.95 | 172.6818181818182 | 91.2975 | 93.47125 | 204.19625
5131 | Long Shoe Horn | 03 Navy | 10 | 9.95 | 19.95 | 18.13636363636363 | 10.4475 | 10.69625 | 21.44625
5081 | Boot Tree Long |  | 5 | 36.95 | 79.95 | 72.68181818181817 | 38.7975 | 39.72125 | 85.94625
5080 | [NAME] |  | 5 | 31.95 | 69.95 | 63.59090909090909 | 33.5475 | 34.34625 | 75.19625
9778 | Footbed |  | 3 | 22.95 | 49.95 | 45.40909090909091 | 24.0975 | 24.67125 | 53.69625000000001
9730 | [NAME] |  | 5 | 40.95 | 89.95 | 81.77272727272727 | 42.9975 | 44.02125 | 96.69625
9419 | Dromoland [NAME] | 03 Navy | S | 40.95 | 89.95 | 81.77272727272727 | 42.9975 | 44.02125 | 96.69625
5126 | Travel [NAME] |  | 5 | 40.95 | 89.95 | 81.77272727272727 | 42.9975 | 44.02125 | 96.69625
5125 | [NAME] | 01 Black | 5 | 13.95 | 29.95 | 27.22727272727272 | 14.6475 | 14.99625 | 32.19625
5085 | Leather Cream | 80 | 12 | 13.95 | 29.95 | 27.22727272727272 | 14.6475 | 14.99625 | 32.19625
5130 | Leather [NAME] | 01 Black, 02 Mid Browns, 88 [NAME] | 12 | 13.95 | 29.95 | 27.22727272727272 | 14.6475 | 14.99625 | 32.19625
1314 | Heel Piece | 01 | S | 12.95 | 26.95 | 24.5 | 13.5975 | 13.92125 | 28.97125
1264 | Footwear Care Trial Pack | 00 | 12 | 13.95 | 29.95 | 27.22727272727272 | 14.6475 | 14.99625 | 32.19625
1263 | Replace a Lace Kit | 00 White, 02 Brown, 03 Navy, 22 Mahogany | 12 | 13.95 | 29.95 | 27.22727272727272 | 14.6475 | 14.99625 | 32.19625
1246 | [NAME] | 00 | 12 | 9.95 | 19.95 | 18.13636363636363 | 10.4475 | 10.69625 | 21.44625
1247 | [NAME] | 00 | 12 | 9.95 | 19.95 | 18.13636363636363 | 10.4475 | 10.69625 | 21.44625
1248 | Footwear Protector | 00 | 12 | 9.95 | 19.95 | 18.13636363636363 | 10.4475 | 10.69625 | 21.44625
9776 | Derrymore | 00 | 5 | 52.95 | 114.95 | 104.5 | 55.5975 | 56.92125 | 123.57125