ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
*The data are relative estimates.*
3
All data based off US Census 2019 Data.
4
Step 1
Go to File -> Make Copy -> Select location and rename file -> then open your personal copy and follow the steps below
5
Step 2Go To Demographics Based on Zip Sheet.
6
Step 3Enter Zip Code You Want Info about below the last filled zip cell.
7
Step 4Drag Formula in column B down to your newly entered Zip Code row.
8
Step 5Double click this cell to access the formula
9
Step 6Change the first thing after =vlookup( to your new zip by only changing the numberExample
You dragged the last formula down from cell B4, and formula looks like: =vlookup($A$4 ...... ) change only the 4 here to a 5, so formula looks like: =vlookup($A$4)
10
Step 7Drag this formula across the row
11
Step 8Done! Enjoy your data.
12
13
14
15
16
17
18
19
20
21
22
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