formatting for different scenarios

[amartino44]

Hello. I have a worksheet with one column of FTE values (# of employees) and an adjacent column that applies a constant salary. To the right, I have 3 columns with different scenarios for the FTE values. Each of these columns has 12 months of FTEs (so, 12 rows). Is there a way to have a drop down with the three scenarios that will apply all of the months FTE to the column on the left? Thanks. Also, if you can think of something cleaner, that would be helpful as well.

[LarryLegend]

Should be easy enough if I understand correctly.

You basically want your first column of FTE values populated with whichever of the 3 scenarios you select from the drop down.

Let's say the dropdown was in Cell A1 and the scenarios are LOW, MEDIUM, HIGH

Column B - FTE Values (based on DropDown)
Column C - Salary
Column D - Low Scenario
Column E - Medium Scenario
Column F - High Scenario

Cell B2 would be =IF($A$1="LOW",D2,IF($A$1="HIGH",F2,E2))
and then you could just copy that down for all of the 12 rows.