Vlookup As a Dropdown List in Google Sheets

Vlookups can easily be used for Dropdown Lists in Google Sheets. If you don't know what Vlookups are about, or how to use them, check our full guide here.

On the matter of creating a dropdown list using the Vlookup function, simply follow these steps:

Total Time: 3 minutes

Data Validation

Using the same file as the one we opened in our vlookup guide, go to the Data menu on the menu toolbar, select the Data Validation dropdown tool, and click Data Validation.

Set Parameters for data validation

Once the pop-up window for the Data Validation comes out, you can set the parameters that you want. For this example, in the Criteria section, you can choose List From a Range. From there, you can click on the Cell box to indicate the column you will include. In this example, we will be using the Name column.


This will net you a dropdown list, much like what you will find in the image below.

Input Parameters

With that done, all you need to do is include the Vlookup function and you basically do it by following the steps in the earlier section of this guide. Only this time, you will use the dropdown Name list as the value.

Name list as the value

What you will then get is a Vlookup function that you can change at will by simply switching between the items in the dropdown list.

Simply switching

Now you can simply select the option you like based on your Vlookup.


  • Sheets