You can use the following syntax with the **VLOOKUP** function in Excel to look up a value in a range and return the corresponding values from multiple columns:

=VLOOKUP(G2,A2:E11,{3,4,5},FALSE)

This particular formula looks in the range **A2:E11** and returns the corresponding values in columns 3, 4, and 5 where the value in column A is equal to **G2**.

**Note**: The **FALSE** argument tells Excel to look for exact matches instead of approximate matches.

The following example shows how to use this syntax in practice.

**Example: Use VLOOKUP to Return Multiple Columns**

Suppose we have the following dataset in Excel that shows information about various basketball teams:

We can use the following formula with **VLOOKUP** to look up the team “Pacers” in column A and return the corresponding values for points, assists, and steals:

=VLOOKUP(G2,A2:E11,{3,4,5},FALSE)

**Note**: After typing this formula, make sure you press **Ctrl+ Shift + Enter**.

The following screenshot shows how to use this formula in practice:

The **VLOOKUP** function returns the values in the points, assists, and steals columns for the row where the team contains “Pacers” in the name.

**Note**: You can find the complete documentation for the **VLOOKUP** function here.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

How to Compare Two Lists in Excel Using VLOOKUP

How to Find Unique Values from Multiple Columns in Excel

How to Filter Multiple Columns in Excel