Results 1 to 23 of 23

Is there a way for selections in a drop-down menu to generate different cell values?

Threaded View

mikeyt354 Is there a way for selections... 12-17-2009, 10:59 PM
solnajeff Re: Is there a way for... 12-17-2009, 11:12 PM
mikeyt354 Re: Is there a way for... 12-17-2009, 11:42 PM
solnajeff Re: Is there a way for... 12-18-2009, 12:41 AM
mikeyt354 Re: Is there a way for... 12-18-2009, 09:32 AM
mikeyt354 Re: Is there a way for... 01-12-2010, 12:52 PM
mikeyt354 Re: Is there a way for... 01-21-2010, 04:35 PM
solnajeff Re: Is there a way for... 01-22-2010, 01:32 PM
mikeyt354 Re: Is there a way for... 01-22-2010, 02:18 PM
mikeyt354 Re: Is there a way for... 01-25-2010, 04:09 PM
solnajeff Re: Is there a way for... 02-02-2010, 07:51 PM
solnajeff Re: Is there a way for... 02-03-2010, 05:55 PM
mikeyt354 Re: Is there a way for... 02-04-2010, 03:31 PM
solnajeff Re: Is there a way for... 02-04-2010, 06:11 PM
  1. #1
    Registered User
    Join Date
    12-17-2009
    Location
    rochester, ny
    MS-Off Ver
    Excel 2010
    Posts
    39

    Is there a way for selections in a drop-down menu to generate different cell values?

    Hey everyone, I'm new to the boards and only moderately familiar with Excel, so I'm looking for a little help. My question might not be completely clear, so I'll try to give you a visualization.

    I want to give users the ability to choose different kinds of expenses from a drop down menu (i.e., Salary, Postage, Supplies). However, some of the expenses have general costs associated with them on top of other costs, and I want it to be made clear by having the proper costs come up with the proper expense. For example:

    A
    1 "Supplies" (is chosen from the drop-down)
    2 "General Supplies" (automatically is generated)
    3 Blank space for them to input a specific supply expense.

    As opposed to:

    B
    1 "Salary" (is chosen from the drop-down)
    2 Blank space for them to input a specific salary expense (because there is no general one associated with salary)

    I have been able to do the first example using the Lookup function, but the problem is that the function is listed in the A2 cell where I would want a blank space if it was for Salary, for example.

    Any ideas would be much appreciated. Hopefully that explanation was somewhat understandable!
    Last edited by teylyn; 01-22-2010 at 04:16 PM. Reason: marked solved at OP's request

Thread Information

Users Browsing this Thread

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

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