You can use the following syntax with the VLOOKUP function in Google Sheets to look up a value in a range and return the corresponding values from multiple columns:
=ArrayFormula(VLOOKUP(A14, A2:D11, {2, 4}, FALSE))
This particular formula looks up the value in cell A14 in the range A2:D11 and returns the corresponding values in columns 2 and 4 of the range.
Note: The FALSE argument tells Google Sheets 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 Google Sheets that shows information about various basketball teams:
We can use the following formula with VLOOKUP to look up the team “Blazers” in column A and return the corresponding values for points and rebounds:
=ArrayFormula(VLOOKUP(A14, A2:D11, {2, 4}, FALSE))
The following screenshot shows how to use this formula in practice:
The VLOOKUP formula returns the values in the points and rebounds columns for the row where the team contains “Blazers” in the name.
Note that if we change the team name in cell A14, the formula will automatically find the points and rebounds values for the new team.
For example, suppose we change the team name to Warriors:
The VLOOKUP formula now returns the values in the points and rebounds columns for the row where the team contains “Warriors” in the name.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Google Sheets: How to Use VLOOKUP From Another Workbook
Google Sheets: Use VLOOKUP to Return All Matches
Google Sheets: Use VLOOKUP with Multiple Criteria