Searching Columns with multi column Combobox

[LightHeart7]

I'm not sure what I need to fix. What it is I have a huge list/table. Column I is vendors, Column B is a location. Some vendors are multiple locations but the same Vendor name. How can I locate these vendors while having a two column Combobox for searching? This is coming off a userform.

Please Login or Register  to view this content.

This worked when I had a single column i was using.

Please Login or Register  to view this content.

I need to be able to find the vendor with name and location since there is multiple repeat vendors

[Tinbendr]

I fill both comboboxes with a unique list of the respective columns. Then, in the combobox change event, I use Range.Find to locate the first combobox value. Then I use offset to look to the second column to see if it matches combobox2. If it does, then I have a match.

Then you need to decide what to do with that find.

to find the vendor

And then do what? If all you need is to identify them in some way, then use auto-filter. I usually display the results in a listbox, along with other columns. But you don't describe what the descrimator will be.

[LightHeart7]

Sorry, i'm trying to identify the row for the Userform. So i may have
Tester 1 - New York
Tester 2 - New York
Tester 3 - Arizona
Tester 1 - California

Well I want to active that row for Tester 1 from California. So that I can pull its information. Not the Tester 1 from New York.

Does that help any?

[Tinbendr]

I want to active that row ...

Then, perform the steps I've indicated, then in the combobox2_Change event use the true If-Then statement to activate the row.

If you could upload a sample worksheet WITH SOME DATA, I can illustrate.

[LightHeart7]

I only had one combo box but having two will be easier. I'll have to make a new forum for this few new questions but thank you. You did help me realize its going to be better to have two then just a multi-column combobox. Easier and more simple in the long run.