In this tutorial, you will learn how to use VLOOKUP to return multiple columns in Excel.
In a cell of a dataset or table in Microsoft Excel, we occasionally need to search for various types of data pertaining to a particular word or piece of information within the text. The VLOOKUP function makes it simple to locate that word in the table and extract information about the cell value that contains it.
Once ready, we’ll get started by utilizing real-world examples to show you how to use VLOOKUP to return multiple columns in Excel.
Table of Contents
Anatomy of VLOOKUP Function
=VLOOKUP(lookup_value, table_array, col_index_number,[range_lookup])
Vertical Lookup is referred to as VLOOKUP. VLOOKUP is a built-in Excel function that, as its name implies, enables you to find a specific value by looking for it vertically across the sheet.
Use VLOOKUP to Return Multiple Columns
Before we begin we will need a group of data to use VLOOKUP to return multiple columns in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want to find the number of stores for California using the VLOOKUP function. To do so, we need to insert the following formula =VLOOKUP(F2,A2:D6,{2,3,4},FALSE).
Step 3
Once you are done, you will be able to use VLOOKUP to return multiple columns in Excel.
