Results 1 to 6 of 6

Two drop down lists, to produce in two other columns

Threaded View

Kneetea Two drop down lists, to... 03-08-2013, 06:24 PM
alansidman Re: Two drop down lists, to... 03-08-2013, 07:00 PM
loginjmor Re: Two drop down lists, to... 03-08-2013, 07:00 PM
Kneetea Re: Two drop down lists, to... 03-08-2013, 07:06 PM
Kneetea Re: Two drop down lists, to... 03-08-2013, 07:22 PM
alansidman Re: Two drop down lists, to... 03-08-2013, 10:28 PM
  1. #1
    Registered User
    Join Date
    03-08-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Two drop down lists, to produce in two other columns

    Hi everyone,
    I'm a very novice excel user and would like help with one of the projects i'm working on at work.

    I made a drop down list in Columb A for Gender (male, female) and in Columb B for Age (19-30, 310-50, 50+)

    What I would like is if someone chose Male from Column A and chose 31-50 range from Column B, In column C it would produce how much fruits they should have eg. 2 serving, ets.

    I have attached what i have so far, I just need help with fomulating the formual. Any help would be appreciated.

    Thank you!
    Attached Files Attached Files

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