Question

  • Creator
    Topic
  • #2148152

    HOW CAN YOU SIMPLIFY A TOO LONG “IF” FUNCTION

    Locked

    by rl_styx ·

    I HAVE A PROBLEM IN MAKING DROPDOWN LIST IN THE CELL.. I WANT TO ASSIGN A LIST IN ANOTHER CELL WHEN I SELECT AN ITEM IN THE DROPDOWN LIST ON THE OTHER..
    EG. WHEN I SELECT APPLE IN THE DROPDOWN LIST IN CELL A1, THE CELL A2 SHOULD HAVE A LIST OF ITS KINDS. SO AS IN B1, WHEN I SELECT ORANGE IN CELL B2, C2 SHOULD HAVE THE DROPDOWN LIST OF ORANGES…
    THE PROBLEM IS, THE SYNTAX IS TOO LONG FOR IT FIT IN THE LIMITED SOURCE BOX IN THE VALIDATION LIST. HOW CAN THIS BE SIMPLIFIED?

    ANYONE… PLS HELP..

All Answers

Viewing 1 reply thread