erutherford
Active Member
- Joined
- Dec 19, 2016
- Messages
- 449
I found some "cascading" combo boxes, but nothing that I could modify to meet my needs. Also there is lots of discussions on "INDEX/MATCH vs VLOOKUP". Its sounds like INDEX/MATCH is what I should be using.
I have two worksheets (pretty simply stuff)
worksheet1 is a "customers" list (cust ID, name, address, city, zip, phone, email).
worksheet2 is a "cars" list (CarID, CustID, yr, model, license plate
I am trying to create a search combobox that searches the "customers" worksheet AND then from that result, creates a combobox to search the "cars", that the selected customer owns.
The results would populate a form, that can be saved into another sheet called "History".
Thanks in advance and looking forward to the solution!
I have two worksheets (pretty simply stuff)
worksheet1 is a "customers" list (cust ID, name, address, city, zip, phone, email).
worksheet2 is a "cars" list (CarID, CustID, yr, model, license plate
I am trying to create a search combobox that searches the "customers" worksheet AND then from that result, creates a combobox to search the "cars", that the selected customer owns.
The results would populate a form, that can be saved into another sheet called "History".
Thanks in advance and looking forward to the solution!
