Autopopulate text based on drop down option


I'm trying to figure out a formula to autopopulate text in a cell based on a drop down option in a previous cell. Basically one column would contain the drop down (Campus) and based on which campus is selected, a different cell (account) would autopopulate.

Ideally it would look like this:

Campus (drop down) Account (auto pop)

Blue 1234

Red 4568

Blue 1234

In looking through the forum, I saw this formula but would need to tweak it a bit in order for it to "hopefully" work: =IF(AND([Cancellation Effective]@row <> "", [Cancellation Effective]@row <= TODAY()), "Inactive", IF([Start Date for Phase 1]@row <= TODAY(), "Active", IF([Start Date for Phase 1]@row >= TODAY(), "Onboarding")))

Any insights would be super helpful!

Best Answer


  • As and update I've tried to play around with the formula and use the IF(AND), but am still getting nowwhere...

    =IF(AND([Campus Name]2 = "Blue", "1234-12", IF(AND([Campus Name]2 = "Red", "4568-12", IF(AND([Campus Name]2 = "Green", "7456-12"))))))

    I got it to work with just one IF condition, but can't seem to move forward with multiple nested rules.

    I'm getting the message "INCORRECT ARGUMENT SET" :(

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Try something like this...

    =IF([email protected] = "Blue", "1234-12", IF([email protected] = "Red", 4568-12", IF([email protected] = "Green", "7456-12")))

  • Hi Paul,

    Unfortunately with that formula I get "UNPARSEABLE"

    Any other thoughts?

    I did get this one to work:

    =IF(AND([Campus Name]2 = "Blue", "1234-12", IF(AND([Campus Name]2 = "Red", "4568-12", IF(AND([Campus Name]2 = "Green", "7456-12"))))))

    but only on "Blue"...for the columns with "Red" or "Green" it came up as #INCORRECT ARGUMENT SET

  • Paul, you're a frickin genius!!!

    Thank you sooooo much. This is amazing. You are amazing.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. 👍️

    Sorry about the initial quotation mark issue.

Help Article Resources