Results 1 to 2 of 2

Thread: Help with "IF Conditions" and Drop Down boxes....

  1. #1

    Help with "IF Conditions" and Drop Down boxes....



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hey all! I am a long time reader of this site and I've learnt a lot about excel but I finally need some assistance on a small side project I am working on.

    I have a spreadsheet with 4 questions (possibly 2 or 3 drop down options per question) and depending how those questions are answered, I would like an answer will generate in two fields.
    e.g.
    Who is emailing?
    What are they enquiring about?
    Do they have VIP support?

    So for example, if John is emailing, he is enquiring about his iPhone, he has VIP support - I want fields B1 to say email and then B2 to have a pre-defined value.

    I really hope this makes sense/is possible.

    I would love to get some direction or advice on this. A similar example would be great to follow along with.

  2. #2
    Conjurer Roger Govier's Avatar
    Join Date
    Mar 2011
    Location
    Located near Abergavenny, South Wales, UK
    Posts
    113
    Articles
    0
    Hi

    Post an example, with some more explanation.
    I cannot really understand what you are asking.
    Regards

    Roger Govier
    Microsoft Excel MVP
    http://www.technology4u.co.uk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •