IF statement with text string

[Dpalma]

Hi,
This is my problem. In cell A1 I have a drop down list created from the data validation tab that say “CARS” and “BIKES”.
In cell A2 – If I selected “CARS” in A1, I want in A2 a drop down list for all components of a car only- E.G. “exhaust, clutch...etc”
Likewise if I selected “Bikes” in A1, I would only want a drop down tab in A2 with all the components of a bike.

The formula I have tried is as below but i need a drop down list instead of only exhausts.

=IF(ISNUMBER(SEARCH("CARS",A1)),exhaust)

[davesexcel]

Check this out
http://contextures.com/xlDataVal02.html

[Dpalma]

Thanks a million. that worked much better. I complicated such an easy matter.
Thanks