Closed Thread
Results 1 to 2 of 2

Google Sheets - Create DropDown from Values using VLookUp

  1. #1
    Registered User
    Join Date
    04-23-2007
    Posts
    34

    Google Sheets - Create DropDown from Values using VLookUp

    Hi, I have a simple sheet that uses a VLookUp to populate an item name based on the item code.

    It's working correctly - however - I'd like the sizes to appear as a dropdown when the code is matched.

    For example - if you choose code 333, it places item name in the row 'orange table'.
    I'd also like to display the sizes for that item in a dropdown in the next column - in this case: long, extra long and double.

    I'm fairly sure this can be done but I cannot find a simple solution via Data Validation - I cannot seem to combine that with my VLookUp formula.

    Thanks in advance for any help.

    https://docs.google.com/spreadsheets...it?usp=sharing

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Google Sheets - Create DropDown from Values using VLookUp

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the newer thread: https://www.excelforum.com/for-other...drop-down.html

    Do NOT do this again. Next time, add the updated information to your existing thread.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Sheets: Vlookup multiple values on different sheets
    By Kdawg1012 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 12-30-2021, 12:05 PM
  2. [SOLVED] Google Sheets DropDown Count
    By yoyoo95 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 04-30-2021, 03:44 AM
  3. Google Sheets to Create Budget Tracker
    By Bjlangbehn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-29-2021, 03:34 AM
  4. Google Sheets: Create a new Sheet on Each Row
    By abdullahsikandar in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-27-2021, 01:05 PM
  5. Adaptive dropdown lists (Google sheets)
    By pessimist101 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 12-31-2018, 09:38 AM
  6. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  7. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1