Hi guys I have an excel worksheet containing a list of supplier product codes and corresponding company product codes. I have set up another worksheet and am using VLOOKUP so that I can enter a supplier code and find our matching code. What I would really like to do is to be able to enter part of the product code in a cell on that page and have it search for that string on the crossreference page and return a list of all supplier codes that contain that string using a formula or code. Basically I suppose I want it to do is a filter with "contains" and display it on the sheet without having to do an advanced or custom filter each time I want to do a search. If anyone can point me in the right direction I will google my way from there. Kind regards brizboy

If I am reading it correctly, what you describe is precisely what advanced filter is made for (you can use wildcard characters). I would use the Office help to see an example before spending time with Google. It's advanced but not very hard.

Hi Maybe I am not being very clear in my question. In VLOOKUP I can enter a value in a cell and then hit the enter key and it will search and display the exact match. If I am reading the use of advanced filter correctly I have to go to via the mouse to the task bar Data>Filter>Advanced Filter each time I want to filter the list. I can't seem to just enter a value in a Cell and hit "Enter" and have the filtered data appear. Is there something simple I am missing. This sheet is used for looking up codes for use on billing sheets and over 2000 codes are checked each a day so I am trying to reduce the number of mouse movements and keystrokes used. I hope that this makes a bit more sense. Kind regards brizboy

I need to ask... Where would this list appear? Within a single cell or drop down list created by this VLOOKUP or? How about with the sheet set as Data, Filter, AutoFilter as selected. Then from the product code drop down select Custom, "begins with" and enter your value? Bryan

I think you can use VLOOKUP as an array formula, or you can create a pretty simple macro to accomplish this. You might have to google 'array formulas for Excel' to get enough insight on them. See what you can come up with. I can help you out if you have trouble.