Spreadsheet: 745339d1629874705-using-vlookup-across-two-sheets-with-multiple-matches-book4-1-
Sheet: Sheet2

SKU | NAME | COLOUR | SIZE | Cost | RRP (incl GST)
3963 | Crosshaven | 03 Navy | 38-48 | 383.95 | 699.95
3857 | Ultima | 01 Black, 02 [NAME], 32 NAVY/BROWN | 35-48 | 328.95 | 599.95
3859 | Ultima Extra Fit | 01 Black, 02 [NAME], 32 NAVY/BROWN | 35-48 | 328.95 | 599.95
3733 | Shamrock | 32 Navy/Brown | 36-48 | 290.95 | 529.95
3745 | Shamrock ExtraFit | 32 Navy/Brown | 37-48 | 290.95 | 529.95
3750 | Fastnet | Carbon | 35-48 | 219.95 | 399.95
3723 | Commodore X LT | 03 Navy, [NAME], 15 Old Rum, 22 MAHOGANY, 32 Navy/Brown,                     95 Chestnut | 40-47 | 165.95 | 359.95
3722 | Sailmaker X LT | 03 Navy,15 [NAME], 19 Whiskey, 22 MAHOGANY, 32 Navy/Brown,               95 Chestnut | 40-47 | 160.95 | 349.95
3831 | Portofino | 00 White, 02 Brown, 03 Navy, 63 [NAME] | tbc | 137.95 | 299.95
3747 | Armada X LT | 02 Brown, 03 Navy, 39 [NAME], 52 Walnut, 63 [NAME] | 40-47 | 160.95 | 349.95
3968 | Atlantic | 03 Navy, 15 Old Rum,  34 Navy/Mahogany, 95 Chestnut | 40-47 | 160.95 | 349.95
3869 | Regatta | 02 Brown, 03 Navy, 15 Old Rum, 32 Navy/Brown, 88 [NAME],   95 Chestnut | 37-48 | 149.95 | 299.95
3878 | Regatta Extra Fit | 03 Navy, 88 Donkey Brown | 40-48 | 149.95 | 299.95
3868 | Yacht | 02 Brown, 03 Navy, 88 [NAME], 95 Chestnut | 40-48 | 149.95 | 299.95
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
3736 | Spinnaker | 02 Brown, 03 Navy | 39-47 | 123.95 | 269.95
3331 | Admirals | 02 Brown, 03 Navy, 34 Navy/Brown | 3-11,12,13 | 114.95 | 249.95
3752 | Tobago | 43 French Navy,  62 Cigar | 41-47 | 137.95 | 299.95
3749 | [NAME] | navy | 40-48 | 151.95 | 329.95
3829 | Antibes | platinum | 35-49 | 110.95 | 239.95
3830 | [NAME] | Graphite , navy | 35-49 | 110.95 | 239.95
3739 | Aruba | 14 Coral, 18 Café, 20 [NAME], 63 Denim, 73 Denim/Tan | 36-42 | 114.95 | 249.95
3740 | Belize | 14 Coral, 18 Café, 20 [NAME],  22 Mahogany, 53 Denim/Red, 55 Caramel, 63 [NAME] | 36-42 | 114.95 | 249.95
3759 | Florida | 27 Café/Carmel, 53 Denim/Red, 73 Denim/Tan | 36-42 | 137.95 | 299.95
3760 | Havana | 27 Café/Carmel, 53 Denim/Red, 73 Denim/Tan | 36-42 | 137.95 | 299.95
3741 | Jamaica | 03 Navy, [NAME],  29  [NAME] white, 33 [NAME] | 36-42 | 137.95 | 299.95
3742 | Bali | 03 Navy, [NAME],  14 Coral | 36-42 | 137.95 | 299.95
3885 | Galway | 01 Black, 02 [NAME], 32 Navy/Brown, 12 Black/Brown, 52 Walnut  , 79 Ivy | 35-48 | 331.95 | 649.95
3931 | Galway Extra Fit | 12 Black/Brown, 32 Navy/Brown*, 52 Walnut | 35-48             *35-43 | 331.95 | 649.95
3934 | [NAME] | 12 Black/Brown, /32 Navy/Brown*, 52 Walnut | 35-45             *35-43 | 331.95 | 649.95
3948 | Sligo | 12 Black/Brown, 52 Walnut, 50 [NAME] | 36-42 | 357.95 | 699.95
3989 | Longford | 01 Black, 12 Black/Brown, 52 Walnut | 35-43 | 357.95 | 699.95
3944 | Glanmire | 02 Brown, 12 Black/Brown, 52 Walnut | 35-43 | 357.95 | 699.95
3892 | Kildare | 01 Black,  02 [NAME], 12 Black/Brown, 32 Navy/Brown, 52 Walnut, 79 Ivy | 35-48 | 296.95 | 579.95
3955 | Clare | 01 Black,  52 Walnut | 36-42 | 357.95 | 699.95
3914 | Wexford | *50 [NAME], 52 Walnut, 79 Ivy* | 37-47        *41-47 | 434.95 | 849.95
3986 | [NAME] | 01 Black, 15 Old Rum, 22 Mahogany, 52 Walnut,  95 Chestnut, | 40-48 | 270.95 | 529.95
3986 | [NAME] | 62 Cigar, 64 Camel | 40-48 | 270.95 | 529.95
3762 | [NAME] | 15 Old Rum | 35-43 | 291.95 | 569.95
3762 | Downpatrick S | 62 Cigar, 64 Camel, 93 Black Suede | 35-43 | 270.95 | 529.95
3946 | [NAME] | 01 Black, 15 Old Rum,  95 Chestnut | 35-43 | 270.95 | 529.95
3946 | [NAME] | 62 Cigar, 64 Camel | 35-43 | 250.95 | 489.95
4001 | Rockpool | 03 Navy, 28 Kingfisher, 56 Cardinal | EU 34-44  UK 8-18 | 154.95 | 339.95
4002 | [NAME] | 03 Navy, 28 [NAME] | EU 34-44  UK 8-18 | 168.95 | 369.95
4003 | Emerald | 00 White Multi, 03 Navy, 28 Kingfisher, 71 Carbon | EU 34-44  UK 8-18 | 109.95 | 239.95
4004 | [NAME] | 00 White Multi, 03 Navy, 28 Kingfisher, 71 Carbon | EU 34-44  UK 8-18 | 99.95 | 219.95
4007 | Lavelle | 28 Kingfisher, 83 Navy Multi | EU 34-44  UK 8-18 | 86.95 | 189.95
4008 | Gregory | 03 Navy, 28 [NAME] | EU 34-44  UK 8-18 | 90.95 | 199.95
4009 | Barleycove | 00 White, 03 Navy, 28 Kingfisher, | EU 34-44  UK 8-18 | 90.95 | 199.95
4013 | Laragh | 03 Navy, 28 Kingfisher, 30 Platinum, 56 Cardinal | EU 34-44  UK 8-18 | 54.95 | 119.95
4015 | Templehouse | 03 Navy, 24 Goldfinch, 30 Platinum, 56 Cardinal | EU 34-44  UK 8-18 | 63.95 | 139.95
4016 | Druid | 03 Navy, 56 Cardinal | EU 34-44  UK 8-18 | 72.95 | 159.95
4018 | Riverview | 00 White, 03 Navy, 28 [NAME],  56 Cardinal | EU 34-44  UK 8-18 | 59.95 | 129.95
3453 | Daffodil | 00 White, 23 Pale Blue, 48 Pale Pink | EU 34-44  UK 8-18 | 72.95 | 159.95
4124 | Chamomile | 00 White, 23 Pale Blue, 48 Pale Pink | EU 34-44  UK 8-18 | 68.95 | 149.95
4174 | Snowdrop | 00 White, 23 Pale Blue, 48 Pale Pink | EU 34-44  UK 8-18 | 68.95 | 149.95
4005 | Barrow | 03 Navy, 28 Kingfisher, 56 Cardinal | S-3XL | 168.95 | 369.95
4006 | Liffey | 03 Navy, 28 Kingfisher, 70 CARBON | S-3XL | 136.95 | 299.95
4011 | Rathwood | 03 Navy, 28 Kingfisher, 70 CARBON | S-3XL | 90.95 | 199.95
4019 | Harcourt | 03 NAVY, 57 IMPERIAL RED, 63 DENIM, 70 GRAPHITE | S-3XL | 68.95 | 149.95
4023 | [NAME] | 03 NAVY,  28 Goldfinch, 28 Kingfisher, 56 Cardinal | S-3XL | 63.95 | 139.95
4027 | Sandymount | 00 White Multi, 87 Blue Multi | S-3XL | 77.95 | 169.95
4250 | [NAME] | 00 White, 23 Pale Blue | S-3XL | 90.95 | 199.95
3612 | Delphi | 03 Navy, 63 [NAME], 66 Oyster | 30-42 | 77.95 | 169.95
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
3511 | [NAME] | 03 Navy, 67 Elm,  86 Sorrel, 89 [NAME], 97 Heath | EU 34-44  UK 8-18 | 404.95 | 799.95
3544 | Hazelwood | 03 Navy, 86 Sorrel, 54 Woodrose, 58 Blue Heather, 67 Elm, 89 Mist | One Size | 232.95 | 459.95
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
3546 | [NAME] | 54 Woodrose,  67 Elm, 86 Sorrel,  89 Mist | EU 34-44  UK 8-18 | 232.95 | 459.95
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
3660 | Ballybrophy | 03 Navy, 09 Olive, 74 Smoke | EU 34-44  UK 8-18 | 249.95 | 549.95
3276 | Spiddal | 09 Olive, 83 Navy Multi, 46 Amber, 96 Spruce | EU 34-44  UK 8-18 | 163.95 | 359.95
3621 | [NAME] | 60 Woodbine, 76 [NAME] | 38-50 | 201.95 | 399.95
3622 | Palmerstown | 01 Black, 03 Navy, 09 Olive | S-3XL | 312.95 | 679.95
3472 | Carrickfergus | 03 Navy, 09 Olive, 49 Dusky Green,  50 [NAME] | S-3XL | 275.95 | 599.95
3667 | Ballymote | 59 Black Watch | S-3XL | 321.95 | 699.95
9456 | Dunlavin | 26 Orchid, 33 [NAME], 55 Carmel | OS | 214.95 | 469.95
9766 | Dunbrody (5) | 01 Black, 32 Navy/Brown, 52 Walnut | OS | 86.95 | 189.95
9781 | [NAME] (5) | 01 Black, 52 Walnut | OS | 68.95 | 149.95
9707 | Rugby (5) | 52 Walnut | OS | 54.95 | 119.95
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
5083 | Boot Liners | 01 Black, 57 Leopard, 60 lynx, 65 Elk, 80 [NAME] | 5 | 22.95 | 49.95
9877 | Gallagher | 03 Navy, 06 Sand, 09 Olive, 17 Bourbon |  | 72.95 | 159.95
9787 | Tullynally | 68  Pheasant |  | 77.95 | 169.95
9834 | Causeway | 03 Navy, 16 Stone, 58 Royal Blue | 5 | 18.95 | 39.95
9833 | Liscannor | 03 Navy, 05 Red, 06  Sand | 5 | 18.95 | 39.95
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
9721 | Butler | 09 [NAME] |  | 131.95 | 289.95
9843 | [NAME] | 83 Midnight, 60 Woodbine |  | 86.95 | 189.95
5131 | Long Shoe Horn | 03 Navy | 10 | 9.95 | 19.95
5081 | Boot Tree Long |  | 5 | 36.95 | 79.95
5080 | [NAME] |  | 5 | 31.95 | 69.95
9778 | Footbed |  | 3 | 22.95 | 49.95
9730 | [NAME] |  | 5 | 40.95 | 89.95
9419 | Dromoland [NAME] | 03 Navy | S | 40.95 | 89.95
5126 | Travel [NAME] |  | 5 | 40.95 | 89.95
5125 | [NAME] | 01 Black | 5 | 13.95 | 29.95
5085 | Leather Cream | 80 | 12 | 13.95 | 29.95
5130 | Leather [NAME] | 01 Black, 02 Mid Browns, 88 [NAME] | 12 | 13.95 | 29.95
1314 | Heel Piece | 01 | S | 12.95 | 26.95
1264 | Footwear Care Trial Pack | 00 | 12 | 13.95 | 29.95
1263 | Replace a Lace Kit | 00 White, 02 Brown, 03 Navy, 22 Mahogany | 12 | 13.95 | 29.95
1246 | [NAME] | 00 | 12 | 9.95 | 19.95
1247 | [NAME] | 00 | 12 | 9.95 | 19.95
1248 | Footwear Protector | 00 | 12 | 9.95 | 19.95
9776 | Derrymore | 00 | 5 | 52.95 | 114.95