+ Reply to Thread
Results 1 to 4 of 4

Cell to show value based on dropdown

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    106

    Cell to show value based on dropdown

    Good morning / good evening all.
    I was wonder if its possible to have a cell with a IF formula so a value based off a dropdown in another cell when selected. For example in A1 i have my dropdown with some names and when i select a certain name A2,A3 and so on would auto fill with the preset name in the formula that matches the name in the drop down. See images for example. And here is the formula that i tried

    =IF($AV1="Amazon", "Caledonia", IF($AV1=iPatio, "Calendonia", if($AV1=Shopify, "Calendonia", if($AV1=Walmart, "Buford", if($AV1=Houzz, "Norwich", If($AV1=Wayfair, "Brampton", if($AV1=Overstock, "Marieville", if($AV1=Sams Club, "Hudson", if($AV1=Home Depot of Canada"",)))))))))

    dropdown.JPG

    Thanks for the time and tips,
    Erick

  2. #2
    Forum Contributor
    Join Date
    11-05-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    155

    Re: Cell to show value based on dropdown

    HI,

    You could write all possible results in a table and then have a vlookup formula? The Vlookup would look for "Amazon" and instead of using a number to represent which corresponding column you want, you can use match. The match will look for the column header and return the corresponding value in the table.

  3. #3
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    106

    Re: Cell to show value based on dropdown

    I get the table, but not sure how that formula would look like.

  4. #4
    Forum Contributor
    Join Date
    11-05-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    155

    Re: Cell to show value based on dropdown

    See example spreadsheet attached
    Attached Files Attached Files

+ 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. Replies: 4
    Last Post: 02-15-2021, 10:11 AM
  2. Show ranges on master based on dropdown
    By Kaizan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2020, 08:46 AM
  3. How to show a table based on a dropdown selection
    By Kerr Beeldens in forum Excel General
    Replies: 7
    Last Post: 08-01-2019, 03:28 PM
  4. Replies: 9
    Last Post: 05-06-2019, 03:57 PM
  5. Show column headings and corresponding values/text based on dropdown selection
    By deedee90 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2018, 07:03 AM
  6. Combo box - Show dropdown arrow when cell is selected
    By gundesvan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-12-2017, 04:37 PM
  7. Show a list of data based from dropdown selection
    By reecerito in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-09-2016, 03:18 AM

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