This needs quite a bit of clarification:
Is the source of your dropdown a form control, an active X control, or data validation?
Do you want formulas in your target cells to evaluate your "dropdown" selection or will you be updating hard coded values based on dropdown selection?

Can you provide a mockup of what you'd like to occur in an example spreadsheet?