I'm trying to figure out how to auto fill values of different cells based on which value I choose from a drop down list in Excel 2007.

I have the drop down list created, and the only way I could figure out to auto fill the values was to do =IF(A2=M2, "Value A", IF(A2=M3, "Value B", IF(A2=M4, "And so on...")))

Several things with this though, if I need to add additional items to the list, I'd have to go through each IF statement and add them, AND, will have multiple columns and rows that I will be tallying.

What's the "easy" way to do this?