Results 1 to 3 of 3

create "if then" with an "or" option or "choose from" option

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2011 for MAC
    Posts
    2

    create "if then" with an "or" option or "choose from" option

    Hi. I would like to be able to pick from the pull down in"C3" and once picked I would like "d3" to give me the options to choose from the corresponding choices from "I" "J" or "K". IN the existing sheet if I pick a product in C3 then go to D3 I can choose from all the sub categories. I only want to choose from the (I-K) specific sub categories. Hopefully that makes sense.

    I created a formula "if then" in cell "M31" which only gives me a single option. I can't seem to expand the formula to include the data and options I want. Possibly not possible. Thought I would ask and perhaps I should be using a different option?

    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)

Tags for this Thread

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