How to use VLOOKUP on an entire column in Google Sheets

In Google Sheets, drag your VLOOKUP formula down a column to apply it to an entire column.
In this example, you'll find a list of Company names based on Domain names to which they belong:

Formula in E12
=VLOOKUP(D12,B\$4:C\$9,2,FALSE)
A
B
C
D
E
F
G
1
2
Column 1
Column 2
3
Domain
Company name
4
5
6
7
8
wikipedia.org
Wikipedia
9
instagram.com
10
11
ID
Email
Domain
Company name
12
1001
👈 Formula is here
13
1002
👇 And dragged down here
14
1003
15
1004
16
1005
17
1006
hyrum@instagram.com
instagram.com
18
1007
19
1008
20
1009
21
1010
benjamin@wikipedia.org
wikipedia.org
Wikipedia
22
1011
23
1012
brooke@wikipedia.org
wikipedia.org
Wikipedia
24
1013
25
1014
26
1015
finn@wikipedia.org
wikipedia.org
Wikipedia
27
1016
28
1017
29
1018
30
1019
trevor@wikipedia.org
wikipedia.org
Wikipedia
31
1020
32
Show arrows
Separator

Procedure

1. Enter =VLOOKUP in cell E12, where you want the Company names to appear.
2. Enter the Lookup value D12, which contains the first domain name of the Domain column (google.com).
3. Enter the Search range B\$4:C\$9, which is the data range containing the Domain and the Company name values.
4. Enter Column number 2 as the Company name column is the 2nd column of the Search range.
5. Enter FALSE to look for an exact match.
6. Drag the formula down through as many cells as there are values in the Domain column (column D).

Result

The final formula is: `=VLOOKUP(D12, B\$4:C\$9, 2, FALSE)`
For each row of the Domain names, VLOOKUP returns the Company names to which they belong.