Drop Down List to change cell

[Rhys G]

In Excel 2007; I need my drop down list to then change the next cell down to a series of different values?
How do i do this? i have created the drop down list, but can't link the values to the item selected in the drop down list.
The JPG attached shows a basic set up of what i am trying to do:
The drop down list contains various product models (yellow)
Once selected this then changes the m2 value (red) which is linked to the formulas in orange; product factor is entered manually.

Thanks
Rhys