VLOOKUP

1
VLOOKUP
Charlie Haffey Norwood Public Schools
2
VlookupVertical Lookup

• Enter a unique value
• Import any info from an internal/external
  database

3
VLookupexample

• Enter the Class group
• VLookup- find name of Dean

4
Vlookup Dialog Box
5
Lookup_value

• Enter value you want to look_up

6

• Enter the Group name
• Have Excel
• find Group info
• locate Dean name
• Enter it for us

7
Wha?
8
Dont Forget to Make array an Absolute
Reference!
9
Col_index_num
2
2
10
Range

• True- closest value
• False- exact match

You are done, baby!
11
Input Your Data
Hit Enter
12

• Go Get A Cold One
• You Deserve It

13
VLOOKUP
Charlie Haffey Norwood Public Schools