Vlookup duplicate values

Hi all,

I have a mental block here, hence the need for some help.

In the attached example, when you search for 'hard' it returns the search string result in ListBox1 but what I want is to then be able to click the values shown in ListBox1 and have ListBox2, 3 and 4 update showing the differing data present in sheet2. What currently happens is that it works for the first but not for the rest.

Any help is appreciated.

Thanks.

Hello
I amended your List Box code to the following:

Please Login or Register  to view this content.

Does this do as you require? It now scrolls through the 'Hard Drive' list for each selection.

DBY

Brilliant, exactly what I was struggling to do. Many thanks DBY

Hello
I was working on this before I saw your second sample file. If the search items are not grouped together then it won't bring back the correct values. I had created a sample file to show one method around this. I'm no VBA expert so there may be a better way but I've created as second list box (hidden) containing all the row numbers of the found items and used that to return the second column value. Take a look and see if it can be applied to your data.

In my eyes, you most certainly are an expert as with that code and some fiddling, I've managed to get it display the results I expected. Awesome

DBY, thank you.

Glad to have helped. I've put your sample data into my file and it seems to work ok. As you say it needs a bit of fiddling to make it all nice but the principle seems to work.

DBY