1 VLOOKUP/IF Input and 2 Outputs? How?

Hi there guys,

I havent done excel for about 2 months now, and i have totally forgotten how to do this....driving me around the bend, so i came across this forum, hoping for some help!

So.... Basically i got a number of drop down lists:

Sector: (User selects this)
Type: (Then the type)
Model: (But each type, has 2 or more model's, so how can i have it return 2 or more model's?

Now that the user has selected the model, that specific model can be leased for a specfic time from that it generates the prices.

How would i go about doing this? I would appreciate anysort of help regarding this issue!

Thanks alot,
Cheers,
Troy.