Table of Contents
VLOOKUP is a function available in Google Sheets that allows users to search for a specific value in a data table and return a corresponding value from a desired column. This function can be used to retrieve data quickly and efficiently, especially when working with large datasets. One of the benefits of using VLOOKUP is its ability to return multiple columns of data at once, making it a useful tool for organizing and analyzing information. To use VLOOKUP for this purpose, users can simply specify the range of columns they want to retrieve data from in the function’s formula. This feature can save time and effort when working with complex data sets, making it a valuable tool for data management and analysis in Google Sheets.
Google Sheets: Use VLOOKUP to Return Multiple Columns
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.
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I use VLOOKUP in Google Sheets to return multiple columns of data?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-vlookup-in-google-sheets-to-return-multiple-columns-of-data/
stats writer. "How can I use VLOOKUP in Google Sheets to return multiple columns of data?." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-vlookup-in-google-sheets-to-return-multiple-columns-of-data/.
stats writer. "How can I use VLOOKUP in Google Sheets to return multiple columns of data?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-vlookup-in-google-sheets-to-return-multiple-columns-of-data/.
stats writer (2024) 'How can I use VLOOKUP in Google Sheets to return multiple columns of data?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-vlookup-in-google-sheets-to-return-multiple-columns-of-data/.
[1] stats writer, "How can I use VLOOKUP in Google Sheets to return multiple columns of data?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use VLOOKUP in Google Sheets to return multiple columns of data?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.