Connect with us


How to Use VLOOKUP with Google Sheets


The VLOOKUP search function is one of the most popular search functions available today because it enables users to look up a value in one database and then use that value in another table. It does what’s known as a “vertical lookup,” which means it searches a specified column vertically for a search key and then returns the value you’re looking for from the same row. This is where the term “vertical lookup” comes from. This is a guide on how to utilise the VLOOKUP function in Google Sheets.

Read Also: How to Create a Google Sheets Drop-Down List

How to Use VLOOKUP with Google Sheets

An illustration is the most helpful tool for grasping the fundamentals of the VLOOKUP function. Imagine that you have a table in a Google Sheet that contains information on the products you have in stock, such as the part number, the name, the price, and so on. If you want to construct a second table that simply contains the part number and price, you could use VLOOKUP to extract the price from the spreadsheet if you know the part number. All you would need to know is the part number.

How to Use VLOOKUP with Google Sheets

1. After inputting the part number you wish to locate, type “=VLOOKUP” into the field that is located directly to the right of it, and then press the tab key to begin entering the formula’s parameters.

2. The first portion of the expression is called the search key, and it is the number of the component that you have just typed into the cell to the left. You can manually enter the value into the formula by typing it in, or you can click the cell to the left to have it automatically entered. Type a comma.

3. The range is the subject of the second argument. You will be required to select the group of columns that should be included in the search. You have the option of typing it, such as “A:E,” or dragging the mouse from the first column header to the last column in the table after clicking on it. Tap in a comma here.

4. The column that contains the value that you are searching for is specified by the third argument. In this particular illustration, we are interested in the price, which can be found in the third column of the range. Simply type a 3, then add a comma after it.

5. After typing “False,” add the closing parentheses to the expression.

The end product will have the following formula: