Hello,
I have a sheet with 2 columns. Column A has Make of the car and column B has the model of that make. Since past 3 days i am googling around and posting on all forums to figure out how can i:
1. Have a dropdown to select "Make" in a cell and
2. Get corresponding model (again in a dropdown) in another cell.
3. Auto complete feature would be a luxury but not a necessity. For eg, i type H and it gives me Honda and Hyundai in drop down.
Please find attached sheet. Getting D3 is easy, i can use LIST and validation. But how do i get E3? Without any helper column? Also i may add more data below in future and it should update automatically. I dont mind giving 10,000 rows as reference in advance.
PS: i can work hard and make sure that Values in column B remain UNIQUE (If that makes things easier) Is it possible to have duplicate values in column B and still have unique values in drop down box?
I tried using all possible functions and data validations and LOTs of helper columns, but i think it's not possible without vba.
Below is my another thread on same issue posted under formulas and functions.
http://www.excelforum.com/excel-form...drop-down.html
Thank you for your time.
Bookmarks