Drop Down List to change cell

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

Hi,

starting from the value in the drop-down list, you can use a lookup formula to find the red value.

Try

=HLOOKUP(B10,B6:L7,2,FALSE)

I don't want to type up all your numbers, so I did not verify the formula. It would be easier if you post a spreadsheet next time.

cheers

No sweat. Could you pls take a moment and mark the thread solved. Forum rules explain why/how