I have a list of items on excel with the option A and B.

I have this list on worksheet 2.

The cell where the list can be selected is A1 on worsheet 1.

Now, I want another list in A2.

I have a further 2 lists of items is also on worksheet 2, in different columns.
they are, for example, a list of car makes and place names

Can I make A2 an IF button that says,
if A1 = A select from the list of carmakes.
If A1 = B select from the list of placenames.

I had a good long hard look at the excel help, but it didn't appear any solution! One of the bright buttons out there may know a way though :)