Autopopulate text based on drop down option

Lauren Ford

Hello!

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!

Paul Newcome

That was my fault. I missed a quotation mark. Try this...

=IF(Campus@row = "Blue", "1234-12", IF(Campus@row = "Red", "4568-12", IF(Campus@row = "Green", "7456-12")))

Lauren Ford

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

Try something like this...

=IF(Campus@row = "Blue", "1234-12", IF(Campus@row = "Red", 4568-12", IF(Campus@row = "Green", "7456-12")))

Lauren Ford

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 Newcome

That was my fault. I missed a quotation mark. Try this...

=IF(Campus@row = "Blue", "1234-12", IF(Campus@row = "Red", "4568-12", IF(Campus@row = "Green", "7456-12")))

Lauren Ford

Paul, you're a frickin genius!!!

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

Paul Newcome

Happy to help. 👍️

Sorry about the initial quotation mark issue.