Using VLOOKUP in Google Sheets

EK17
VlookupAssignment.xlsx
Home>English homework help>Using VLOOKUP in Google Sheets

1Vlookup

Number Address City Selling Agent List Price Selling Price Listing Date Sale Date
1 8687 Kenwood Road Cedar Hills Hernandez $ 725,000 $ 645,250 4/1/12 6/16/12 Number
2 11 West Oak Circle American Fork Carey $ 350,000 $ 340,000 4/1/12 5/15/12
3 314 Timp View Drive American Fork Goodrich $ 418,000 $ 400,000 4/1/12 6/1/12 Address
4 614 West Cedar Drive Lehi Lugo $ 215,800 $ 200,000 4/1/12 5/25/12 City
5 750 South Apple Way American Fork Goodrich $ 385,900 $ 385,900 4/1/12 4/30/12 Selling Agent
6 7 Kingston Court Alpine Carey $ 500,000 $ 465,000 4/3/12 6/10/12 List Price
7 618 West Cedar Drive Lehi Lugo $ 300,000 $ 290,000 4/3/12 6/1/12 Selling Price
8 321 North Choctaw American Fork Minkus $ 565,000 $ 535,000 4/6/12 9/30/12 Listing Date
9 1370 Pinellas Road Alpine Lugo $ 219,000 $ 215,000 4/8/12 6/2/12 Sale Date
10 1971 Glenview Road Lehi Minkus $ 165,000 $ 156,750 4/12/12 6/12/12
11 15 West Oak Circle American Fork Hernandez $ 325,000 $ 320,000 4/12/12 5/30/12
12 575 South Choctaw Alpine Goodrich $ 750,250 $ 700,000 4/12/12 11/1/12
13 10995 SW 88 Court Lehi Goodrich $ 110,000 $ 106,000 4/12/12 7/3/12
14 143 North Mountain View American Fork Carey $ 314,250 $ 304,000 4/13/12 8/5/12
15 29 East Oak Circle American Fork Merkin $ 555,000 $ 500,000 4/13/12 10/15/12
16 8030 Steeplechase Drive Alpine Merkin $ 450,000 $ 382,500 4/15/12 6/30/12
17 2006 Cutwater Court Alpine Minkus $ 345,000 $ 339,999 4/18/12 6/23/12
18 9876 South Sunset Avenue Eagle Mountain Hernandez $ 300,000 $ 300,000 4/18/12 4/30/12
19 321 West Walnut Grove American Fork Goodrich $ 425,000 $ 415,000 4/18/12 6/30/12
20 4081 Lybyer Avenue Alpine Minkus $ 325,000 $ 308,750 4/19/12 7/2/12
21 1900 Glenview Road Lehi Hernandez $ 325,000 $ 302,250 4/28/12 6/1/12
22 9000 South Sunset Avenue Eagle Mountain Lugo $ 325,000 $ 320,000 4/28/12 5/28/12
23 8432 South Sunset Avenue Eagle Mountain Minkus $ 285,750 $ 300,000 4/28/12 6/3/12
24 831 South Weber American Fork Lugo $ 425,815 $ 400,000 4/28/12 9/15/12
25 714 Timp View Lane American Fork Goodrich $ 250,000 $ 232,000 4/29/12 9/1/12
26 240 East Jefferson Way Eagle Mountain Lugo $ 515,000 $ 485,750 4/29/12 8/25/12
27 224 Rockaway Street Alpine Pijuan $ 400,000 $ 375,000 4/30/12 6/19/12
28 260 East Jefferson Way Eagle Mountain Hernandez $ 450,000 $ 400,000 4/30/12 10/1/12
29 290 East Jefferson Way Eagle Mountain Pijuan $ 310,000 $ 300,000 4/30/12 7/1/12
30 8307 S Indian River Drive Lehi Hernandez $ 250,000 $ 255,000 5/1/12 6/18/12
31 123 Ivy Lane Eagle Mountain Pijuan $ 375,500 $ 375,500 5/1/12 5/5/12
32 9408 Forest Hills Circle Cedar Hills Reuter $ 185,500 $ 179,000 5/1/12 6/6/12
33 245 Ivy Lane Eagle Mountain Goodrich $ 395,000 $ 375,000 5/1/12 7/16/12
34 11971 SW 269 Terrace Cedar Hills Carey $ 410,000 $ 397,700 5/1/12 6/26/12
35 1857 Pine Drive Cedar Hills Hernandez $ 560,700 $ 550,000 5/1/12 5/30/12
36 3461 East Lindon Way American Fork Reuter $ 450,000 $ 400,000 5/2/12 9/30/12
37 16235 Orange Boulevard Cedar Hills Lugo $ 395,000 $ 380,000 5/5/12 7/16/12
38 614 Lincoln Drive Eagle Mountain Reuter $ 475,000 $ 425,250 5/5/12 9/23/12
39 2448 Woodacres Road Lehi Hernandez $ 450,000 $ 382,500 5/5/12 6/16/12
40 401 Pinecone Circle Alpine Goodrich $ 1,500,120 $ 1,400,000 5/5/12 9/30/12
40 401 Pinecone Circle Alpine Goodrich $ 1,500,120 $ 1,400,000 5/5/12 9/30/12
41 421 Ivy Lane Eagle Mountain Pijuan $ 500,000 $ 425,000 5/5/12 11/15/12
42 765 East Sheridan Lane Eagle Mountain Minkus $ 460,750 $ 435,500 5/5/12 11/1/12
43 61 East Walnut Grove American Fork Goodrich $ 375,000 $ 376,000 5/6/12 5/15/12
44 1414 N Sheridan Road Alpine Pijuan $ 1,250,000 $ 1,225,000 5/12/12 6/6/12
45 487 Blue Skies Drive American Fork Goodrich $ 365,750 $ 355,000 5/13/12 8/15/12
46 10700 Lake Shore Lane Cedar Hills Carey $ 650,000 $ 598,000 5/15/12 6/9/12
47 73 East Oak Street Eagle Mountain Merkin $ 325,000 $ 325,000 5/18/12 5/31/12
48 81 Island Drive South Alpine Bethune $ 147,800 $ 150,000 5/22/12 6/16/12
49 3412 Kilmer Street Lehi Carey $ 180,000 $ 175,000 5/23/12 7/15/12
50 605 Reservoir Drive Alpine Reuter $ 310,000 $ 291,400 5/22/12 6/29/12
50 605 Reservoir Drive Alpine Reuter $ 310,000 $ 291,400 5/22/12 6/29/12
51 77 East Oak Street Eagle Mountain Bethune $ 345,000 $ 335,000 5/23/12 6/23/12
52 400 Ivy Lane Eagle Mountain Bethune $ 375,000 $ 330,000 5/26/12 8/30/12
53 1 Southampton Place Lehi Goodrich $ 215,000 $ 195,000 5/28/12 6/18/12
54 3418 North Sunset Lane Eagle Mountain Bethune $ 450,000 $ 400,000 5/28/12 8/15/12
55 1892 North 250 West American Fork Carey $ 315,250 $ 300,000 5/28/12 8/1/12
56 1629 NW 43rd Street Cedar Hills Carey $ 475,000 $ 450,000 5/31/12 8/19/12
57 3400 North Sunset Lane Eagle Mountain Merkin $ 400,000 $ 375,000 5/31/12 7/15/12
58 876 South California Way American Fork Hen $ 316,000 $ 316,000 5/31/12 6/30/12
59 21 Compass Road Cedar Hills Merkin $ 289,900 $ 279,000 5/31/12 6/1/12
60 34 West Oakley Drive American Fork Carey $ 345,000 $ 330,000 6/1/12 8/15/12
60 34 West Oakley Drive American Fork Carey $ 345,000 $ 330,000 6/1/12 8/15/12
61 30 Kent Road Lehi Bethune $ 259,900 $ 246,905 6/2/12 9/2/12
62 140 East 3rd Street Eagle Mountain Hen $ 399,000 $ 350,000 6/2/12 11/30/12
63 160 West 5th Street Eagle Mountain Carey $ 410,000 $ 350,750 6/3/12 10/15/12
64 240 West 5th Street Eagle Mountain Reuter $ 285,750 $ 300,000 6/5/12 7/1/12
65 520 E Spring Street Alpine Minkus $ 189,900 $ 186,102 6/6/12 7/26/12
66 678 Mountain Circle American Fork Goodrich $ 335,000 $ 330,000 6/10/12 9/15/12
67 3490 North Sunset Lane Eagle Mountain Minkus $ 250,000 $ 275,000 6/12/12 6/25/12
68 4916 Rock Spring Road Cedar Hills Lugo $ 275,000 $ 264,000 6/13/12 7/21/12
69 8923 Harris Drive Alpine Minkus $ 589,000 $ 575,000 6/18/12 7/8/12
70 876 West Hadley Way American Fork Hernandez $ 345,670 $ 345,000 6/20/12 9/30/12
70 876 West Hadley Way American Fork Hernandez $ 345,670 $ 345,000 6/20/12 9/30/12
71 1132 SW 52nd Street Cedar Hills Hernandez $ 254,500 $ 236,685 6/23/12 9/21/12
72 416 East Oak Eagle Mountain Merkin $ 300,000 $ 250,000 6/23/12 11/2/12
73 10 Vestal Drive Cedar Hills Carey $ 555,000 $ 565,000 6/24/12 6/30/12
74 425 East Oak Eagle Mountain Bethune $ 275,900 $ 250,000 6/24/12 8/15/12
75 876 West Holiday Alpine Goodrich $ 475,000 $ 455,000 6/24/12 9/18/12
76 103 Jasper Drive Lehi Bethune $ 165,900 $ 159,264 6/29/12 9/6/12
77 516 East Oak Eagle Mountain Pijuan $ 299,999 $ 280,000 6/29/12 9/30/12
78 123 Oak Avenue American Fork Carey $ 400,000 $ 400,000 6/30/12 7/15/12
79 600 Ivy Lane Eagle Mountain Pijuan $ 339,999 $ 310,000 6/30/12 10/1/12
80 144 Oak Avenue American Fork Goodrich $ 380,500 $ 365,000 6/30/12 9/1/12
80 144 Oak Avenue American Fork Goodrich $ 380,500 $ 365,000 6/30/12 9/1/12
81 1600 Reeves Street Cedar Hills Reuter $ 245,900 $ 233,605 6/30/12 8/16/12

2Vlookup

Item Package Date Department Unit Price
727-7174 6/3/18 Yogurt $ 1.25 Item
921-2237 5/7/18 Milk $ 2.50
770-2235 6/22/18 Ice Cream $ 4.99 Package Date
230-4865 5/20/18 Sour Cream $ 1.50 Department
914-6193 6/16/18 Butter $ 2.75 Unit Price
521-4371 6/6/18 Butter $ 2.75
146-8099 6/22/18 Yogurt $ 1.25
484-3093 6/10/18 Cheese $ 2.99
197-7688 6/1/18 Sour Cream $ 1.50
790-3526 5/7/18 Cheese $ 2.99
438-4198 6/23/18 Cheese $ 2.99
782-4530 5/22/18 Yogurt $ 1.25
523-6603 6/14/18 Ice Cream $ 4.99
215-3721 6/5/18 Sour Cream $ 1.50
306-6985 6/26/18 Yogurt $ 1.25
557-7377 6/24/18 Sour Cream $ 1.50
485-7265 6/4/18 Yogurt $ 1.25
728-1197 6/10/18 Milk $ 2.50
950-1232 7/1/18 Sour Cream $ 1.50
441-3659 5/12/18 Milk $ 2.50
151-7554 6/15/18 Milk $ 2.50
685-3084 6/18/18 Sour Cream $ 1.50
376-4933 6/9/18 Cheese $ 2.99
979-1833 6/12/18 Ice Cream $ 4.99
318-5509 6/13/18 Milk $ 2.50
234-4965 6/11/18 Ice Cream $ 4.99
900-6144 6/17/18 Ice Cream $ 4.99
139-4702 6/25/18 Milk $ 2.50
363-4533 5/4/18 Cheese $ 2.99
249-8059 6/17/18 Butter $ 2.75
917-1824 6/20/18 Sour Cream $ 1.50
708-5956 6/6/18 Ice Cream $ 4.99
333-3659 6/24/18 Butter $ 2.75
953-3070 6/5/18 Ice Cream $ 4.99
334-4475 6/19/18 Ice Cream $ 4.99
514-3918 6/3/18 Cheese $ 2.99
903-5522 6/25/18 Butter $ 2.75
332-8499 5/16/18 Butter $ 2.75
152-8635 7/1/18 Butter $ 2.75
961-4860 6/19/18 Butter $ 2.75
364-6597 6/11/18 Yogurt $ 1.25
423-2329 6/15/18 Sour Cream $ 1.50
971-6678 6/28/18 Ice Cream $ 4.99
709-4139 6/15/18 Sour Cream $ 1.50
153-1803 6/26/18 Yogurt $ 1.25
279-3772 6/27/18 Yogurt $ 1.25
132-4948 6/24/18 Butter $ 2.75
223-7673 6/1/18 Cheese $ 2.99
332-8608 6/15/18 Yogurt $ 1.25
886-6675 6/20/18 Ice Cream $ 4.99
127-2111 6/21/18 Cheese $ 2.99
505-9959 6/28/18 Ice Cream $ 4.99
713-9601 6/24/18 Milk $ 2.50
571-7137 7/1/18 Sour Cream $ 1.50
189-2098 6/11/18 Cheese $ 2.99
489-1554 6/6/18 Cheese $ 2.99
189-8632 6/23/18 Butter $ 2.75
619-2524 6/10/18 Ice Cream $ 4.99
569-1267 6/23/18 Sour Cream $ 1.50
501-4703 6/15/18 Ice Cream $ 4.99
294-3017 6/7/18 Yogurt $ 1.25
779-6675 6/7/18 Milk $ 2.50
339-8236 6/15/18 Butter $ 2.75
718-1817 6/27/18 Sour Cream $ 1.50
338-5247 6/10/18 Ice Cream $ 4.99
106-8721 6/21/18 Ice Cream $ 4.99
894-4740 6/6/18 Butter $ 2.75
379-8312 6/8/18 Yogurt $ 1.25
777-6287 6/25/18 Milk $ 2.50
623-1005 6/29/18 Milk $ 2.50
829-8487 6/12/18 Ice Cream $ 4.99
227-5440 6/23/18 Cheese $ 2.99
416-5304 6/3/18 Butter $ 2.75
916-8884 6/20/18 Butter $ 2.75
112-9891 6/16/18 Cheese $ 2.99
410-7344 6/13/18 Yogurt $ 1.25
607-6392 6/5/18 Milk $ 2.50
670-8107 6/15/18 Butter $ 2.75
389-6516 6/24/18 Sour Cream $ 1.50
136-6749 6/30/18 Milk $ 2.50
435-8755 6/25/18 Cheese $ 2.99
757-2959 6/14/18 Cheese $ 2.99
232-9582 6/3/18 Yogurt $ 1.25
413-9783 6/20/18 Butter $ 2.75
468-1823 6/21/18 Cheese $ 2.99
151-6939 6/10/18 Ice Cream $ 4.99
597-3398 6/12/18 Cheese $ 2.99
436-6368 6/22/18 Ice Cream $ 4.99
868-9767 6/28/18 Ice Cream $ 4.99
973-1877 6/7/18 Cheese $ 2.99
383-4929 6/27/18 Cheese $ 2.99
918-9748 6/19/18 Milk $ 2.50
114-5439 6/11/18 Butter $ 2.75
210-7645 6/28/18 Butter $ 2.75
364-2623 6/30/18 Milk $ 2.50
451-5453 6/5/18 Cheese $ 2.99
968-5694 6/14/18 Cheese $ 2.99
313-5933 6/16/18 Cheese $ 2.99
444-4350 6/30/18 Cheese $ 2.99
638-6282 5/1/18 Ice Cream $ 4.99