+ Reply to Thread
Results 1 to 3 of 3

Need value in cell to reflect choice of drop down menu in adjacent cell

  1. #1
    Registered User
    Join Date
    08-20-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    2

    Cool Need value in cell to reflect choice of drop down menu in adjacent cell

    I have created a drop down list with 5 different city names for choices. I am trying to get the cell next to it to reflect the outcome of cell on another worksheet based on the city choice. On the other worksheet I have each city with different shipping rates varied by weight. This worksheet will be hidden. I have gotten one of the cities to work properly but I am at a loss on how to get all 5 working. Any ideas? I used this code to get one city working. =IF((A4={"Houston"}),Formulas!C1)
    Last edited by den2cool; 08-20-2013 at 04:50 PM.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Need value in cell to reflect choice of drop down menu in adjacent cell

    Sounds like the VLOOKUP function in the adjacent cell might be one possible way forward.
    Martin

  3. #3
    Registered User
    Join Date
    08-20-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Need value in cell to reflect choice of drop down menu in adjacent cell

    Thanks, I was heading on that path but was not sure if it was the correct way to go. My only problem was when looking into the VLookup it appear to me the cells must be on same worksheet.
    Last edited by den2cool; 08-20-2013 at 05:01 PM.

+ 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. Hello Everyone
    By den2cool in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-21-2013, 09:13 PM
  2. VBA referencing drop down menu, and calulating based on choice in menu
    By rheinevetter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2013, 08:16 PM
  3. [SOLVED] Cell reference based on another cell choice from a drop down list.
    By enoch5939 in forum Excel General
    Replies: 2
    Last Post: 12-07-2012, 12:04 PM
  4. Replies: 2
    Last Post: 04-30-2012, 12:00 PM
  5. Drop down menu, need a choice added
    By shanshine in forum Excel General
    Replies: 4
    Last Post: 09-28-2011, 03:37 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