OK folks my first ever post!

I have been using the INDEX and MATCH function but can't quite get to what I need...

Cell A1 has 3 options to select a car manufacture in the form of a pull down list
Ford, BMW, A N Other

I want cell B1 to populate a different pull down list dependant the manufacture selected in cell A1 e.g.

Cell A1: Ford is picked

Cell B1: Displays Ford car menu with 4 options (Focus, Mondeo, Fiesta, S Max)

If the user picks the Cell A1 - BMW then I would like cell B1 to show the BMW cars available.


Any ideas