Can you use an If...Then Formula to populate multiple columns?
I am looking to create a formula that will auto populate three columns depending on what region is chosen.
If the region chosen is the Northeast then I want Person 1, 2 & 3 to auto populate.
If the region chosen is the Mid-Atlantic then I want Person 1, 4 & 5 to populate...and so on.
Is this possible? I tried the vlookup but it was too row specific.
Help Article Resources
Check out the Formula Handbook template!