Rome Diamond League Live Recap
Watch on Youtube

Excel forumla/function help needed

Non-Running Other
Reply
Moderation

  • need excel help

    Anonymous Poster

    15 years ago 01/30/2011 9:42pm EST

    Need some help for those excel gurus out there.

    I have a cell (A1) with a drop down list of items (4 items non-numerical). In another cell (A2), I want to be able to do a calculation based on the selection made in cell A1. What function do I use to be able to do this?

    For instance, A1 - pick red, blue, green, or yellow.

    In A2 - if red, then do this. if blue, then do this..and so on.

    Can someone help me out? Is this the if..then function??

  • getabrain

    Anonymous Poster

    15 years ago 01/30/2011 10:13pm EST
    re: need excel help

    =if(a1="red", red thing, if(a1="blue", blue thing, if(a1="green", green thing, if(a1="yellow", yellow thing, "Pick a Color"))))

  • need excel help

    Anonymous Poster

    15 years ago 01/30/2011 10:21pm EST
    re: getabrain

    thanks!

  • registered

    Knacker

    Member since 08/24/2010.

    221 posts. Last post 4 years ago.
    15 years ago 01/31/2011 10:48am EST
    re: need excel help

    Or, if you have lots of items, create a lookup table on another sheet(sorted alphabetically), e.g.

    Blue 36

    Green 98

    Red 22

    Purple 27

    Yellow 87

    ...

    Then simply use the vlookup function, e.g. VLOOKUP(dropdownfieldcell,tablerange,FALSE).

  • registered

    Knacker

    Member since 08/24/2010.

    221 posts. Last post 4 years ago.
    15 years ago 01/31/2011 10:49am EST
    re: Knacker

    Left out the column ref:

    VLOOKUP(dropdownfieldcell,tablerange,2,FALSE)

What People Are Talking About On LetsRun
No top threads at the moment. Check back soon.
New Forum Moderation Information & Rules Search Troubleshooting

This thread has already been deleted.

Note: We review 100% of reports submitted. Visit our moderation dashboard to view statistics on our moderating activity. If you have a question or concern, email us at letsrun@letsrun.com or call us at our toll-free phone number:

1-844-LETSRUN (1-844-538-7786).

Author
Body
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?
What forum rule may this post have broken?

View our Terms Of Service for a complete description of our forum policies.

Provide context for this post report if relevant.

Reply Replying to

Leave the password field blank to post anonymously.

Post Preview
By posting you acknowledge that you have read and abide by our Terms and Conditions.

Message Board