Partial Match Return Results

[tccontact]

I have in one sheet in Column A a list of codes like: 1441a,1441f, 1441u, etc.
Column B lists the Product Name that the code corresponds to: Widget - Basic, Widget - Deluxe, Widget - Extreme, etc.

Column A will have different instances of this, so there can also be 4234a, 4234b, etc. and 9458a, 9458u, so I don't know how many cases there are with near matches.

I would love to either:
a) do some sort of VLOOKUP-type function where I could (if I put these codes on another workbook) return all Product Names if a partial match on the code is found. So anytime there is a match on the first four digits, all Product Names would be returned. So in this case a match would be found on 1441, and I would therefore see all the different names of the Widget product, and a match would be found on 4234, and 9458.

OR:
b) Perhaps this is easier - filter the column of codes or return results to me to show me any where there is a match of the first four digits/characters.



Apologies if this is long-winded and confusing. Thank you.

 

[rdw72777]

Create a column that just has the first four digits, using the LEFT function. then create a pivot table and use this newly created column as one of your row fields and bring in the Product name field as a second row field.

 

[tccontact]

Thanks, that'll work!