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)
Bookmarks