Bonus 3: VLOOKUP

	A	B	C	D	E
1	Intructions: When we have several columns of text and want to look up info from one column, that is keyed to a different column, we can use VLOOKUP. To do this we follow this general format:
2
3
4
5	Formula =VLOOKUP(ITEM,CELL:CELL,COLUMN,FALSE)
6
7	Name	Favorite Color		Name	Favorite Soft Drink
8	Dan	Green		Dan	No Sugar
9	Jeff	Blue		Jeff	Coke Zero
10	Katie	Brown		Katie	Fanta
11	Kim	Yellow		Kim	Coke
12	Liz	Orange		Liz	Pepsi
13	Rebecca	Aqua		Rebecca	Orange Crush
14	Ryan	Cyan		Ryan	Root Beer
15
16	What is this person's favorite color?	Result below \/		What is this person's favorite soft drink?	Result below \/
17	Jeff	Blue		Ryan
18	Try changing a name in cell A17.				Create your own formula above
19
20
21
22	Sample Video and Instructions on How to use VLOOKUP		Help on VLOOKUP
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100