+ Reply to Thread
Results 1 to 3 of 3

Dropdown Option Changes Another Cells Value

Hybrid View

glafser Dropdown Option Changes... 03-04-2014, 03:10 PM
Xx7 Re: Dropdown Option Changes... 03-04-2014, 03:21 PM
glafser Re: Dropdown Option Changes... 03-04-2014, 03:25 PM
  1. 03-04-2014, 03:10 PM #1
    glafser is offline
    Registered User
    Join Date
    03-04-2014
    Location
    St. Louis
    MS-Off Ver
    Excel 2007
    Posts
    4

    Dropdown Option Changes Another Cells Value

    Hi and thanks for your time beforehand!

    I am trying to make a cell next to a dropdown option change its value based on the option selected. As you can see in the screen shot, I am trying to make S24:25 change its value to the corresponding number in S21:27. So if 60F is chosen in the drop down menu I'd like cell S24:25 to show 1.11. Please let me know what to do, thanks so much! I've been researching this for the past two days so I at least tried to do my homework before posting!


    Screenshot 2014-03-04 12.58.03.png
    Last edited by glafser; 03-04-2014 at 03:25 PM.
    Reply With QuoteRegister To Reply
  2. 03-04-2014, 03:21 PM #2
    Xx7 is offline
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Dropdown Option Changes Another Cells Value

    You need a lookup function in the cell. Like this...

    =VLOOKUP(R24,$O$21:$P$27,2,0)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 03-04-2014, 03:25 PM #3
    glafser is offline
    Registered User
    Join Date
    03-04-2014
    Location
    St. Louis
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Dropdown Option Changes Another Cells Value

    Xx7 Thanks so much for the quick reply! That worked great!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Seperate Based On Dropdown Option
    By trevor2524 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2013, 04:14 PM
  2. How to make a dropdown option dependent on a previous dropdown selection??
    By Bill Williams in forum Excel General
    Replies: 2
    Last Post: 08-11-2011, 01:32 AM
  3. Dropdown option triggers data in row to be copied to new tab
    By DotsAndMagnets in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2011, 11:29 AM
  4. Once a dropdown option is selected it triggers a value to appear in another box
    By gouverneurcc in forum Excel General
    Replies: 3
    Last Post: 05-09-2011, 04:56 PM
  5. Dropdown - option is picked it will return a date
    By MrJennings in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2008, 12:38 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1