Formula for populating a column (1st column) based on a drop down (2nd column)

godwinm2 · 01/31/25

Data to populate column is in a source sheet

Paul Newcome · 01/31/25

Are you able to provide more details?

Cybulski · 01/31/25

I would use several nested IF functions:

=If({Column 2}="dropdown opt.1", "value you want", If({Column 2}="dropdown opt.2", "value you want, If({Column 2}="dropdown opt.3", "value you want", "")

You can just keep adding IFs until you have all the option and then put "" at the end so column 1 will stay blank if none of the dropdowns in column 2 have been chosen.