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.

Time needed: 3 minutes.

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

  1. 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.
    data validation vlookup dropdown

  2. 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.
    data validations settings dropdown google sheets

  3. Dropdown

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

  4. 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.
    input parameters vlookup dropdown

  5. 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.
    name list as value vlookup dropdown

  6. Simply switching

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

Leave a Comment

Your email address will not be published. Required fields are marked *