11222B3

Table of Contents
1 Overview
2 VLOOKUP Definition
3 VLOOKUP Uses
4 Write a VLOOKUP
5 Errors
6 First Match & Sorting
7 Relationships
8 Lookup Tables
9 VLOOKUP Challenge
10 Source

This Table of Contents was created in

one click with the Tab Hound Add-in.
learn more
[Link]
 What are we going to learn?

Introduction to VLOOKUP
1 Definition & Uses
2 How to Write a VLOOKUP Formula
3 The Two Main Causes of Errors
4 Stops at First Match & The Sorting Myth
5 Creating Relationships Between Tables
VLOOKUP Definition:
Look for a value in a column and
return a result from a cell in the
row where a match is found.
Allows us to answer questions:
What is the price of a Caffe Mocha
size Grande?

Always looks to the Right!

What can we use VLOOKUP for?

Create Relationships Between Data & Lookup Tables

Search Tables & Databases

Interactive Reports & Financial Models

 Use drop-down menu
for dynamic inputs.

Tax & Commission Rate Calculations

How to Write a VLOOKUP Formula

CLASSIC FAVORITES TALL GRANDE VENTI

Caffe Latte $2.95 $3.75 $4.15
Cappuccino $2.95 $3.65 $4.15
Caramel Macchiato $3.75 $3.95 $4.25
Caffe Mocha $3.25 $3.95 $4.40
White Chocolate Mocha $3.45 $4.15 $4.55
Caffe Americano $2.00 $2.40 $2.75
Cinnamon Dolce Latte $3.95 $4.75 $5.15
Drip Coffee $1.75 $1.95 $2.05

Question: What is the price of a Caffe Mocha, size Grande?

Caffe Mocha 3.95
The Two Main Causes of Errors

CLASSIC FAVORITES TALL GRANDE VENTI

Caffe Latte $2.95 $3.75 $4.15
Cappuccino $2.95 $3.65 $4.15
Caramel Macchiato $3.75 $3.95 $4.25
Caffe Mocha $3.25 $3.95 $4.40
White Chocolate Mocha $3.45 $4.15 $4.55
Caffe Americano $2.00 $2.40 $2.75
Cinnamon Dolce Latte $3.95 $4.75 $5.15
Drip Coffee $1.75 $1.95 $2.05

Question: How much will this order cost for size Grandes?
Grande
White Chocolate Mocha $4.15
Caffe Latte $3.75
Caramel Macchiato $3.95
Caffe Mocha $3.95
Total $15.80
Stops at First Match & Sorting Data

CLASSIC FAVORITES TALL GRANDE VENTI

Caffe Latte $2.95 $3.75 $4.15
Cappuccino $2.95 $3.65 $4.15
White Chocolate Mocha $3.45 $4.15 $4.55
Caffe Mocha $3.25 $3.95 $4.40 Vlookup STOPS when it finds
Caramel Macchiato $3.75 $3.95 $4.25 the first match.
Caffe Mocha $2.25 $2.50 $2.75
Cinnamon Dolce Latte $3.95 $4.75 $5.15
Steamer $2.25 $2.50 $2.75 Sort Ascending is NOT required
for EXACT match Vlookup
Drip Coffee $1.75 $1.95 $2.05

Question: What is the price of a Caffe Mocha, size Grande?

Caffe Mocha
Create Relationships Between Tables - VLOOKUP to Other Sheets

Order ID Customer ID Salesperson Product Name Revenue Product Category

1001 27 Mariya Sergienko Wine $ 686.00 Beverages
1002 27 Mariya Sergienko Dried Plums $ 164.50 Dried Fruit & Nuts
1003 4 Andrew Cencini Dried Pears $ 2,070.00 Dried Fruit & Nuts
1004 4 Andrew Cencini Dried Apples $ 4,717.00 Dried Fruit & Nuts
1005 4 Andrew Cencini Dried Plums $ 38.50 Dried Fruit & Nuts
1006 12 Mariya Sergienko Chai $ 1,458.00 Beverages
1007 12 Mariya Sergienko Coffee $ 2,024.00 Beverages
1008 8 Nancy Freehafer Chocolate Biscuits Mix $ 349.60 Baked Goods & Mixes
1009 4 Andrew Cencini Chocolate Biscuits Mix $ 809.60 Baked Goods & Mixes
1010 29 Jan Kotas Chocolate $ 1,198.50 Candy
1011 3 Mariya Sergienko Clam Chowder $ 878.15 Soups
1012 6 Michael Neipper Curry Sauce $ 1,280.00 Sauces
1013 28 Anne Larsen Coffee $ 2,530.00 Beverages
1014 8 Nancy Freehafer Chocolate $ 599.25 Candy
1015 10 Laura Giussani Green Tea $ 269.10 Beverages
1016 7 Nancy Freehafer Coffee $ 1,104.00 Beverages
1017 10 Laura Giussani Boysenberry Spread $ 850.00 Jams, Preserves
1018 10 Laura Giussani Cajun Seasoning $ 374.00 Condiments
1019 10 Laura Giussani Chocolate Biscuits Mix $ 404.80 Baked Goods & Mixes
1020 11 Anne Larsen Dried Plums $ 283.50 Dried Fruit & Nuts
1021 11 Anne Larsen Green Tea $ 146.51 Beverages
1022 1 Nancy Freehafer Chai $ 756.00 Beverages
1023 1 Nancy Freehafer Coffee $ 2,668.00 Beverages
1024 1 Nancy Freehafer Green Tea $ 200.33 Beverages
1025 28 Anne Larsen Clam Chowder $ 965.00 Soups
1026 28 Anne Larsen Crab Meat $ 1,159.20 Canned Meat
1028 9 Robert Zare Mozzarella $ 2,818.80 Dairy Products
1029 6 Michael Neipper Wine $ 994.00 Beverages
1030 8 Nancy Freehafer Curry Sauce $ 1,280.00 Sauces
1031 3 Mariya Sergienko Syrup $ 630.00 Condiments
1032 3 Mariya Sergienko Curry Sauce $ 1,200.00 Sauces
1033 6 Michael Neipper $ 1.00 #N/A
1034 28 Anne Larsen $ 1.00 #N/A
1035 8 Nancy Freehafer $ 1.00 #N/A
1036 10 Laura Giussani Cajun Seasoning $ 470.00 Condiments
1038 10 Laura Giussani Dried Plums $ 171.50 Dried Fruit & Nuts
1039 11 Anne Larsen Curry Sauce $ 2,880.00 Sauces
1040 1 Nancy Freehafer Crab Meat $ 239.20 Canned Meat
1041 28 Anne Larsen Coffee $ 1,472.00 Beverages
1042 9 Robert Zare Clam Chowder $ 260.55 Soups
1043 6 Michael Neipper Chocolate $ 905.25 Candy
1044 8 Nancy Freehafer Chocolate $ 165.75 Candy
1045 25 Laura Giussani Cajun Seasoning $ 2,156.00 Condiments
1046 26 Anne Larsen Boysenberry Spread $ 525.00 Jams, Preserves
1047 29 Jan Kotas Coffee $ 1,014.00 Beverages
1048 6 Michael Neipper Dried Pears $ 2,880.00 Dried Fruit & Nuts
1049 6 Michael Neipper Dried Apples $ 848.00 Dried Fruit & Nuts
1051 3 Mariya Sergienko Green Tea $ 224.25 Beverages
1053 9 Robert Zare Mozzarella $ 382.80 Dairy Products
1054 6 Michael Neipper Coffee $ 742.00 Beverages
1055 8 Nancy Freehafer Curry Sauce $ 3,400.00 Sauces
1056 8 Nancy Freehafer Chocolate Biscuits Mix $ 892.40 Baked Goods & Mixes
1057 25 Laura Giussani Green Tea $ 460.00 Beverages
1059 26 Anne Larsen Clam Chowder $ 936.05 Soups
1060 26 Anne Larsen Crab Meat $ 1,196.00 Canned Meat
1061 29 Jan Kotas Curry Sauce $ 1,008.00 Sauces
1062 6 Michael Neipper Chocolate $ 204.00 Candy
1064 4 Andrew Cencini Dried Pears $ 6,237.00 Dried Fruit & Nuts
1067 8 Nancy Freehafer Mozzarella $ 2,192.40 Dairy Products
1070 3 Mariya Sergienko Syrup $ 480.00 Condiments
1071 3 Mariya Sergienko Curry Sauce $ 2,840.00 Sauces
1075 10 Laura Giussani Boysenberry Spread $ 550.00 Jams, Preserves
1077 10 Laura Giussani Dried Plums $ 73.50 Dried Fruit & Nuts
1078 11 Anne Larsen Curry Sauce $ 2,680.00 Sauces
1079 1 Nancy Freehafer Crab Meat $ 1,380.00 Canned Meat
1080 28 Anne Larsen Coffee $ 782.00 Beverages
1081 4 Andrew Cencini Dried Plums $ 168.00 Dried Fruit & Nuts
1082 12 Mariya Sergienko Chai $ 1,332.00 Beverages
1083 12 Mariya Sergienko Coffee $ 4,416.00 Beverages
1084 8 Nancy Freehafer Chocolate Biscuits Mix $ 110.40 Baked Goods & Mixes
1085 4 Andrew Cencini Chocolate Biscuits Mix $ 570.40 Baked Goods & Mixes
1086 29 Jan Kotas Chocolate $ 446.25 Candy
1087 3 Mariya Sergienko Clam Chowder $ 916.75 Soups
1088 6 Michael Neipper Curry Sauce $ 680.00 Sauces
1089 28 Anne Larsen Coffee $ 4,416.00 Beverages
1090 8 Nancy Freehafer Chocolate $ 1,058.25 Candy
1091 10 Laura Giussani Green Tea $ 263.12 Beverages
1092 7 Nancy Freehafer Coffee $ 2,714.00 Beverages
1093 10 Laura Giussani Boysenberry Spread $ 675.00 Jams, Preserves
1094 10 Laura Giussani Cajun Seasoning $ 814.00 Condiments
1095 10 Laura Giussani Chocolate Biscuits Mix $ 690.00 Baked Goods & Mixes
1096 11 Anne Larsen Dried Plums $ 248.50 Dried Fruit & Nuts
1097 11 Anne Larsen Green Tea $ 263.12 Beverages
1098 1 Nancy Freehafer Chai $ 990.00 Beverages
1099 29 Jan Kotas Chocolate $ 178.50 Candy
1100 3 Mariya Sergienko Clam Chowder $ 414.95 Soups
1101 6 Michael Neipper Curry Sauce $ 2,520.00 Sauces
1102 28 Anne Larsen Coffee $ 1,656.00 Beverages
1103 8 Nancy Freehafer Chocolate $ 522.75 Candy
1104 10 Laura Giussani Green Tea $ 104.65 Beverages
1105 7 Nancy Freehafer Coffee $ 1,426.00 Beverages
1106 10 Laura Giussani Boysenberry Spread $ 1,300.00 Jams, Preserves
1107 10 Laura Giussani Cajun Seasoning $ 660.00 Condiments
1108 10 Laura Giussani Chocolate Biscuits Mix $ 377.20 Baked Goods & Mixes
1109 11 Anne Larsen Dried Plums $ 154.00 Dried Fruit & Nuts
1110 11 Anne Larsen Green Tea $ 230.23 Beverages
1111 1 Nancy Freehafer Chai $ 522.00 Beverages
1112 1 Nancy Freehafer Coffee $ 3,542.00 Beverages
1113 1 Nancy Freehafer Green Tea $ 218.27 Beverages
1114 28 Anne Larsen Clam Chowder $ 714.10 Soups
1115 28 Anne Larsen Crab Meat $ 460.00 Canned Meat
1117 9 Robert Zare Mozzarella $ 1,287.60 Dairy Products
1118 6 Michael Neipper Cajun Seasoning $ 1,176.00 Condiments
1119 8 Nancy Freehafer Curry Sauce $ 2,920.00 Sauces
1120 8 Nancy Freehafer Chocolate Biscuits Mix $ 469.20 Baked Goods & Mixes
1121 25 Laura Giussani Chocolate Biscuits Mix $ 660.00 Baked Goods & Mixes
1123 26 Anne Larsen Clam Chowder $ 839.55 Soups
1124 26 Anne Larsen Crab Meat $ 1,177.60 Canned Meat
1125 29 Jan Kotas Dried Plums $ 294.00 Dried Fruit & Nuts
1126 6 Michael Neipper Chocolate $ 242.25 Candy
1128 4 Andrew Cencini Syrup $ 1,863.00 Condiments
1131 8 Nancy Freehafer Mozzarella $ 765.60 Dairy Products
1134 3 Mariya Sergienko Syrup $ 820.00 Condiments
1135 3 Mariya Sergienko Curry Sauce $ 3,920.00 Sauces
1138 7 Nancy Freehafer Coffee $ 3,266.00 Beverages
1139 10 Laura Giussani Boysenberry Spread $ 1,000.00 Jams, Preserves
1140 10 Laura Giussani Cajun Seasoning $ 1,760.00 Condiments
1141 10 Laura Giussani Chocolate Biscuits Mix $ 349.60 Baked Goods & Mixes
1142 11 Anne Larsen Dried Plums $ 98.00 Dried Fruit & Nuts
1143 11 Anne Larsen Green Tea $ 179.40 Beverages
1144 1 Nancy Freehafer Chai $ 594.00 Beverages
1145 1 Nancy Freehafer Coffee $ 1,012.00 Beverages
1146 1 Nancy Freehafer Green Tea $ 152.49 Beverages
1147 28 Anne Larsen Clam Chowder $ 579.00 Soups
1148 28 Anne Larsen Crab Meat $ 1,803.20 Canned Meat
1150 9 Robert Zare Mozzarella $ 3,062.40 Dairy Products
1151 6 Michael Neipper Green Tea $ 910.00 Beverages
1152 8 Nancy Freehafer Curry Sauce $ 1,520.00 Sauces
1153 8 Nancy Freehafer Chocolate Biscuits Mix $ 736.00 Baked Goods & Mixes
1154 25 Laura Giussani Chocolate Biscuits Mix $ 490.00 Baked Goods & Mixes
1156 26 Anne Larsen Clam Chowder $ 579.00 Soups
1157 26 Anne Larsen Crab Meat $ 717.60 Canned Meat
1158 29 Jan Kotas Green Tea $ 1,106.00 Beverages
1159 6 Michael Neipper Chocolate $ 561.00 Candy
1161 4 Andrew Cencini Wine $ 7,938.00 Beverages
1164 8 Nancy Freehafer Mozzarella $ 1,044.00 Dairy Products
1167 3 Mariya Sergienko Syrup $ 240.00 Condiments
1168 3 Mariya Sergienko Curry Sauce $ 1,120.00 Sauces
1172 10 Laura Giussani Dried Plums $ 740.00 Dried Fruit & Nuts
1174 10 Laura Giussani Dried Plums $ 315.00 Dried Fruit & Nuts
1175 11 Anne Larsen Curry Sauce $ 1,080.00 Sauces
1176 1 Nancy Freehafer Crab Meat $ 1,306.40 Canned Meat
1177 28 Anne Larsen Coffee $ 3,404.00 Beverages
1178 9 Robert Zare Clam Chowder $ 733.40 Soups
1179 6 Michael Neipper Chocolate $ 1,224.00 Candy
1180 8 Nancy Freehafer Chocolate $ 1,173.00 Candy
1181 25 Laura Giussani Cajun Seasoning $ 2,046.00 Condiments
1182 26 Anne Larsen Boysenberry Spread $ 450.00 Jams, Preserves
1183 29 Jan Kotas Cajun Seasoning $ 3,822.00 Condiments
1184 6 Michael Neipper Dried Pears $ 1,380.00 Dried Fruit & Nuts
1185 6 Michael Neipper Dried Apples $ 742.00 Dried Fruit & Nuts
1187 3 Mariya Sergienko Green Tea $ 263.12 Beverages
1188 1 Nancy Freehafer Green Tea $ 242.19 Beverages
1189 28 Anne Larsen Clam Chowder $ 318.45 Soups
1190 28 Anne Larsen Crab Meat $ 864.80 Canned Meat
1192 9 Robert Zare Mozzarella $ 939.60 Dairy Products
1193 6 Michael Neipper Clam Chowder $ 1,176.00 Soups
1194 8 Nancy Freehafer Curry Sauce $ 3,640.00 Sauces
1195 8 Nancy Freehafer Chocolate Biscuits Mix $ 331.20 Baked Goods & Mixes
1196 25 Laura Giussani Syrup $ 340.00 Condiments
1198 26 Anne Larsen Clam Chowder $ 241.25 Soups
1199 26 Anne Larsen Crab Meat $ 220.80 Canned Meat
1200 29 Jan Kotas Coffee $ 322.00 Beverages
1201 6 Michael Neipper Chocolate $ 969.00 Candy
1203 4 Andrew Cencini Dried Apples $ 4,455.00 Dried Fruit & Nuts
1206 8 Nancy Freehafer Mozzarella $ 939.60 Dairy Products
1209 3 Mariya Sergienko Syrup $ 990.00 Condiments
1210 3 Mariya Sergienko Curry Sauce $ 400.00 Sauces
1214 10 Laura Giussani Wine $ 800.00 Beverages
1216 10 Laura Giussani Dried Plums $ 94.50 Dried Fruit & Nuts
1217 11 Anne Larsen Curry Sauce $ 3,880.00 Sauces
1218 1 Nancy Freehafer Crab Meat $ 772.80 Canned Meat
1219 28 Anne Larsen Coffee $ 1,104.00 Beverages
1220 9 Robert Zare Clam Chowder $ 868.50 Soups
1221 6 Michael Neipper Chocolate $ 357.00 Candy
1222 28 Anne Larsen Coffee $ 1,288.00 Beverages
1223 8 Nancy Freehafer Chocolate $ 726.75 Candy
1224 10 Laura Giussani Green Tea $ 68.77 Beverages
1225 7 Nancy Freehafer Coffee $ 3,956.00 Beverages
1226 10 Laura Giussani Boysenberry Spread $ 1,175.00 Jams, Preserves
1227 10 Laura Giussani Cajun Seasoning $ 2,134.00 Condiments
1228 10 Laura Giussani Chocolate Biscuits Mix $ 883.20 Baked Goods & Mixes
1229 11 Anne Larsen Dried Plums $ 108.50 Dried Fruit & Nuts
1230 11 Anne Larsen Green Tea $ 155.48 Beverages
1231 1 Nancy Freehafer Chai $ 1,638.00 Beverages
1232 1 Nancy Freehafer Coffee $ 644.00 Beverages
1233 1 Nancy Freehafer Green Tea $ 131.56 Beverages
1234 28 Anne Larsen Clam Chowder $ 936.05 Soups
1235 28 Anne Larsen Crab Meat $ 1,472.00 Canned Meat
1237 9 Robert Zare Mozzarella $ 1,113.60 Dairy Products
1238 6 Michael Neipper Wine $ 728.00 Beverages
1239 8 Nancy Freehafer Curry Sauce $ 3,120.00 Sauces
1240 8 Nancy Freehafer Chocolate Biscuits Mix $ 496.80 Baked Goods & Mixes
1241 25 Laura Giussani Chai $ 550.00 Beverages
1243 26 Anne Larsen Clam Chowder $ 183.35 Soups
1244 26 Anne Larsen Crab Meat $ 1,214.40 Canned Meat
1245 29 Jan Kotas Syrup $ 588.00 Condiments
1246 6 Michael Neipper Chocolate $ 918.00 Candy
1248 4 Andrew Cencini Crab Meat $ 2,592.00 Canned Meat
1250 10 Laura Giussani Chocolate Biscuits Mix $ 763.60 Baked Goods & Mixes
1251 11 Anne Larsen Dried Plums $ 318.50 Dried Fruit & Nuts
1252 11 Anne Larsen Green Tea $ 191.36 Beverages
1253 1 Nancy Freehafer Chai $ 1,044.00 Beverages
1254 1 Nancy Freehafer Coffee $ 4,462.00 Beverages
1255 1 Nancy Freehafer Green Tea $ 41.86 Beverages
1256 28 Anne Larsen Clam Chowder $ 656.20 Soups
1257 28 Anne Larsen Crab Meat $ 588.80 Canned Meat
1259 9 Robert Zare Mozzarella $ 1,983.60 Dairy Products
1260 6 Michael Neipper Wine $ 938.00 Beverages
1261 8 Nancy Freehafer Curry Sauce $ 1,920.00 Sauces
1262 8 Nancy Freehafer Chocolate Biscuits Mix $ 708.40 Baked Goods & Mixes
1263 25 Laura Giussani Chocolate $ 940.00 Candy
1265 26 Anne Larsen Clam Chowder $ 414.95 Soups
1266 26 Anne Larsen Crab Meat $ 1,306.40 Canned Meat
1267 29 Jan Kotas Mozzarella $ 700.00 Dairy Products
1268 6 Michael Neipper Chocolate $ 1,224.00 Candy
1270 4 Andrew Cencini Dried Plums $ 4,374.00 Dried Fruit & Nuts
1273 8 Nancy Freehafer Mozzarella $ 2,192.40 Dairy Products
1276 3 Mariya Sergienko Syrup $ 710.00 Condiments
1277 3 Mariya Sergienko Curry Sauce $ 3,520.00 Sauces
1281 10 Laura Giussani Chai $ 590.00 Beverages
1282 6 Michael Neipper Curry Sauce $ 3,760.00 Sauces
1283 28 Anne Larsen Coffee $ 3,956.00 Beverages
1284 8 Nancy Freehafer Chocolate $ 777.75 Candy
1285 10 Laura Giussani Green Tea $ 95.68 Beverages
1286 7 Nancy Freehafer Coffee $ 2,852.00 Beverages
1287 10 Laura Giussani Boysenberry Spread $ 1,500.00 Jams, Preserves
1288 10 Laura Giussani Cajun Seasoning $ 1,122.00 Condiments
1289 10 Laura Giussani Chocolate Biscuits Mix $ 450.80 Baked Goods & Mixes
1290 11 Anne Larsen Dried Plums $ 70.00 Dried Fruit & Nuts
1291 11 Anne Larsen Green Tea $ 146.51 Beverages
1292 1 Nancy Freehafer Chai $ 396.00 Beverages
1293 1 Nancy Freehafer Coffee $ 3,358.00 Beverages
1294 1 Nancy Freehafer Green Tea $ 254.15 Beverages
1295 28 Anne Larsen Clam Chowder $ 424.60 Soups
1296 28 Anne Larsen Crab Meat $ 441.60 Canned Meat
1298 9 Robert Zare Mozzarella $ 2,436.00 Dairy Products
1299 6 Michael Neipper Cajun Seasoning $ 1,372.00 Condiments
1300 8 Nancy Freehafer Curry Sauce $ 1,920.00 Sauces
1301 8 Nancy Freehafer Chocolate Biscuits Mix $ 920.00 Baked Goods & Mixes
1302 25 Laura Giussani Chai $ 900.00 Beverages
1304 26 Anne Larsen Clam Chowder $ 685.15 Soups
1305 26 Anne Larsen Crab Meat $ 184.00 Canned Meat
1306 29 Jan Kotas Dried Apples $ 1,092.00 Dried Fruit & Nuts
1307 6 Michael Neipper Chocolate $ 561.00 Candy
1309 4 Andrew Cencini Cajun Seasoning $ 6,642.00 Condiments
1312 8 Nancy Freehafer Mozzarella $ 3,236.40 Dairy Products
1315 3 Mariya Sergienko Syrup $ 110.00 Condiments
1316 3 Mariya Sergienko Curry Sauce $ 3,640.00 Sauces
1320 10 Laura Giussani Crab Meat $ 120.00 Canned Meat
1322 10 Laura Giussani Dried Plums $ 273.00 Dried Fruit & Nuts
1323 11 Anne Larsen Curry Sauce $ 2,400.00 Sauces
1324 1 Nancy Freehafer Crab Meat $ 423.20 Canned Meat
1325 28 Anne Larsen Coffee $ 1,564.00 Beverages
1326 9 Robert Zare Clam Chowder $ 858.85 Soups
1327 6 Michael Neipper Chocolate $ 1,045.50 Candy
1328 8 Nancy Freehafer Chocolate $ 548.25 Candy
1329 10 Laura Giussani Cajun Seasoning $ 2,112.00 Condiments
1330 10 Laura Giussani Chocolate Biscuits Mix $ 312.80 Baked Goods & Mixes
1331 11 Anne Larsen Dried Plums $ 147.00 Dried Fruit & Nuts
1332 11 Anne Larsen Green Tea $ 299.00 Beverages
1333 1 Nancy Freehafer Chai $ 756.00 Beverages
1334 1 Nancy Freehafer Coffee $ 736.00 Beverages
1335 1 Nancy Freehafer Green Tea $ 65.78 Beverages
1336 28 Anne Larsen Clam Chowder $ 443.90 Soups
1337 28 Anne Larsen Crab Meat $ 1,840.00 Canned Meat
1339 9 Robert Zare Mozzarella $ 2,018.40 Dairy Products
1340 6 Michael Neipper Dried Pears $ 1,190.00 Dried Fruit & Nuts
1341 8 Nancy Freehafer Curry Sauce $ 1,120.00 Sauces
1342 8 Nancy Freehafer Chocolate Biscuits Mix $ 174.80 Baked Goods & Mixes
1343 25 Laura Giussani Mozzarella $ 990.00 Dairy Products
1345 26 Anne Larsen Clam Chowder $ 357.05 Soups
1346 26 Anne Larsen Crab Meat $ 1,177.60 Canned Meat
1347 29 Jan Kotas Dried Apples $ 532.00 Dried Fruit & Nuts
1348 6 Michael Neipper Chocolate $ 191.25 Candy
1350 4 Andrew Cencini Coffee $ 4,212.00 Beverages
1353 8 Nancy Freehafer Mozzarella $ 835.20 Dairy Products
1356 3 Mariya Sergienko Syrup $ 360.00 Condiments
1357 3 Mariya Sergienko Curry Sauce $ 960.00 Sauces
1361 10 Laura Giussani Coffee $ 200.00 Beverages
1363 10 Laura Giussani Dried Plums $ 38.50 Dried Fruit & Nuts
1364 11 Anne Larsen Curry Sauce $ 3,120.00 Sauces
1365 1 Nancy Freehafer Crab Meat $ 1,398.40 Canned Meat
1366 28 Anne Larsen Coffee $ 2,622.00 Beverages
1367 9 Robert Zare Clam Chowder $ 135.10 Soups
1368 27 Mariya Sergienko Green Tea $ 196.00 Beverages
1369 27 Mariya Sergienko Dried Plums $ 245.00 Dried Fruit & Nuts
1370 4 Andrew Cencini Dried Pears $ 3,000.00 Dried Fruit & Nuts
1371 4 Andrew Cencini Dried Apples $ 1,431.00 Dried Fruit & Nuts
1372 4 Andrew Cencini Dried Plums $ 245.00 Dried Fruit & Nuts
1373 12 Mariya Sergienko Chai $ 1,026.00 Beverages
1374 12 Mariya Sergienko Coffee $ 3,818.00 Beverages
1375 8 Nancy Freehafer Chocolate Biscuits Mix $ 699.20 Baked Goods & Mixes
1376 4 Andrew Cencini Chocolate Biscuits Mix $ 736.00 Baked Goods & Mixes
1377 29 Jan Kotas Chocolate $ 599.25 Candy
1378 3 Mariya Sergienko Clam Chowder $ 926.40 Soups
1379 6 Michael Neipper Curry Sauce $ 1,280.00 Sauces
1380 28 Anne Larsen Coffee $ 736.00 Beverages
1381 8 Nancy Freehafer Chocolate $ 522.75 Candy
1382 10 Laura Giussani Green Tea $ 122.59 Beverages
1383 7 Nancy Freehafer Coffee $ 1,886.00 Beverages
1384 10 Laura Giussani Boysenberry Spread $ 2,350.00 Jams, Preserves
1385 10 Laura Giussani Cajun Seasoning $ 440.00 Condiments
1386 10 Laura Giussani Chocolate Biscuits Mix $ 119.60 Baked Goods & Mixes
1387 11 Anne Larsen Dried Plums $ 259.00 Dried Fruit & Nuts
1388 11 Anne Larsen Green Tea $ 158.47 Beverages
1389 1 Nancy Freehafer Chai $ 1,782.00 Beverages
1390 1 Nancy Freehafer Coffee $ 4,094.00 Beverages
1391 1 Nancy Freehafer Green Tea $ 191.36 Beverages
1392 28 Anne Larsen Clam Chowder $ 945.70 Soups
1393 28 Anne Larsen Crab Meat $ 1,582.40 Canned Meat
1395 9 Robert Zare Mozzarella $ 2,401.20 Dairy Products
1396 6 Michael Neipper Curry Sauce $ 952.00 Sauces
1397 8 Nancy Freehafer Curry Sauce $ 2,080.00 Sauces
1398 8 Nancy Freehafer Chocolate Biscuits Mix $ 368.00 Baked Goods & Mixes
1399 25 Laura Giussani Cajun Seasoning $ 1,000.00 Condiments
1401 26 Anne Larsen Clam Chowder $ 443.90 Soups
1402 26 Anne Larsen Crab Meat $ 1,711.20 Canned Meat
1403 29 Jan Kotas Cajun Seasoning $ 1,344.00 Condiments
1404 6 Michael Neipper Chocolate $ 153.00 Candy
1406 4 Andrew Cencini Coffee $ 3,078.00 Beverages
1409 8 Nancy Freehafer Mozzarella $ 3,480.00 Dairy Products
1412 3 Mariya Sergienko Syrup $ 890.00 Condiments
1413 3 Mariya Sergienko Curry Sauce $ 480.00 Sauces
1417 10 Laura Giussani Dried Plums $ 970.00 Dried Fruit & Nuts
1419 10 Laura Giussani Dried Plums $ 185.50 Dried Fruit & Nuts
1420 11 Anne Larsen Curry Sauce $ 2,440.00 Sauces
1421 1 Nancy Freehafer Crab Meat $ 828.00 Canned Meat
1422 28 Anne Larsen Coffee $ 1,978.00 Beverages
1423 9 Robert Zare Clam Chowder $ 173.70 Soups
1424 6 Michael Neipper Chocolate $ 522.75 Candy
1425 8 Nancy Freehafer Chocolate $ 242.25 Candy
1426 25 Laura Giussani Cajun Seasoning $ 1,430.00 Condiments
1427 26 Anne Larsen Boysenberry Spread $ 325.00 Jams, Preserves
1428 29 Jan Kotas Chocolate Biscuits Mix $ 2,106.00 Baked Goods & Mixes
1429 6 Michael Neipper Dried Pears $ 990.00 Dried Fruit & Nuts
1430 6 Michael Neipper Dried Apples $ 1,802.00 Dried Fruit & Nuts
1432 3 Mariya Sergienko Green Tea $ 71.76 Beverages
#N/A
#N/A
Rep's Region
West
West
East
East
East
West
West
North
East
West
West
North
South
North
East
North
East
East
East
South
South
North
North
North
South
South
West
North
North
West
West
North
South
North
East
East
South
North
South
West
North
North
East
South
West
North
North
West
West
North
North
North
East
South
South
West
North
East
North
West
West
East
East
South
North
South
East
West
West
North
East
West
West
North
South
North
East
North
East
East
East
South
South
North
West
West
North
South
North
East
North
East
East
East
South
South
North
North
North
South
South
West
North
North
North
East
South
South
West
North
East
North
West
West
North
East
East
East
South
South
North
North
North
South
South
West
North
North
North
East
South
South
West
North
East
North
West
West
East
East
South
North
South
West
North
North
East
South
West
North
North
West
North
South
South
West
North
North
North
East
South
South
West
North
East
North
West
West
East
East
South
North
South
West
North
South
North
East
North
East
East
East
South
South
North
North
North
South
South
West
North
North
North
East
South
South
West
North
East
East
South
South
North
North
North
South
South
West
North
North
North
East
South
South
West
North
East
North
West
West
East
North
South
North
East
North
East
East
East
South
South
North
North
North
South
South
West
North
North
North
East
South
South
West
North
East
North
West
West
East
East
South
North
South
West
North
North
East
East
South
South
North
North
North
South
South
West
North
North
North
East
South
South
West
North
East
North
West
West
East
East
South
North
South
West
West
West
East
East
East
West
West
North
East
West
West
North
South
North
East
North
East
East
East
South
South
North
North
North
South
South
West
North
North
North
East
South
South
West
North
East
North
West
West
East
East
South
North
South
West
North
North
East
South
West
North
North
West
Lookup Tables

Product Name Category Salesperson City State

Wine Beverages Mariya Sergienko Las Vegas NV
Dried Plums Dried Fruit & Nuts Andrew Cencini New York NY
Dried Pears Dried Fruit & Nuts Nancy Freehafer Las Vegas NV
Dried Apples Dried Fruit & Nuts Jan Kotas New York NY
Chai Beverages Michael Neipper Portland OR
Coffee Beverages Anne Larsen Portland OR
Chocolate Biscuits Mix Baked Goods & Mixes Laura Giussani Milwaukee WI
Chocolate Candy Robert Zare Los Angeles CA
Clam Chowder Soups
Curry Sauce Sauces
Green Tea Beverages
Boysenberry Spread Jams, Preserves
Cajun Seasoning Condiments
Crab Meat Canned Meat
Ravioli Pasta
Mozzarella Dairy Products
Syrup Condiments
Extension Manager Plan Region Customer ID Customer Name
5689 Kyla Walker Gold West 1 Tagchat
5674 Kyla Walker Platinum East 3 Centizu
5612 Kyla Walker Gold North 4 Divanoodle
5638 Grant Franklin Silver West 6 Layo
5641 Celeste Dalton Platinum North 7 Cogilith
5675 Grant Franklin Silver South 8 Dabjam
5688 Celeste Dalton Platinum East 9 Topicblab
5618 Celeste Dalton Gold West 10 Einti
11 Voonix
12 Ooba
25 Zoozzy
26 Jabberstorm
27 Devpulse
28 Thoughtbridge
29 Fliptune
[Link]
Author:

YouTube Video:
Blog Post:
VLOOKUP Challenge:
Free Excel Pro Tips Newsletter:
Jon Acampora

[Link]
[Link]
[Link]
[Link]