+ Reply to Thread
Results 1 to 2 of 2

Autofill a cell based on Drop-down List Selection

  1. #1
    Registered User
    Join Date
    04-03-2017
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    1

    Question Autofill a cell based on Drop-down List Selection

    Hi,

    If there is drop-down list containing various values, based on the value selected on the drop down list there should be a value which should be auto completed on another cell. I have seen many tutorials and they were all based on indirect function(where based on the selection made in the drop down list, few more selections appear in another drop-down). But i want the autocompleted value to be set by default along with the other regular depending cascading lists.

    eg. cell A2 contains a list of book titles. when i select a book from A2, B2 should contain a default value of "xyz" which is common for all the books, c2 should contain another drop down which is relevent to the type of book selected from A2

    Thanks.

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Autofill a cell based on Drop-down List Selection

    I think you are thinking about this in a way too complicated way.
    What I believe you are after (correct me if I am wrong) is in B2 for example you just need a formula like...
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    i.e. if A2 is blank then leave B2 blank otherwise show xyz
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change reference cell in formula based on selection in drop down list
    By devin.fentie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-13-2016, 03:40 AM
  2. Return value based on selection chosen from drop-down list in cell next to it
    By b624333 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-03-2014, 07:45 PM
  3. Autofill a cell based on selection in drop down menu
    By fyrfytr265 in forum Excel General
    Replies: 4
    Last Post: 01-30-2014, 10:35 AM
  4. Populate data in cell based on drop down list selection
    By dwoodson297 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2013, 02:07 PM
  5. Autofill cell based on drop-down selection
    By littlebird6180 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2012, 03:09 PM
  6. [SOLVED] Autofill text based on drop-down selection in different cells (VBA)
    By GarryR in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-04-2012, 09:43 AM
  7. [SOLVED] Cell auto fill based on another field drop down list selection
    By pugulis in forum Excel General
    Replies: 3
    Last Post: 03-22-2012, 07:38 AM

Tags for this Thread

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