You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.
  • I went on a ramble about making all the possible combos of a, b, and c in a reference table and then using filter based on cell value to spit out the answer.

    that's how much i dislike drop down menus.
    you could still use if and statements but type them into cells that the statements reference rather than a drop down.
    that's again how much i hate drop down filters.

About

Avatar for Chalfie @Chalfie started