CODEWITHSUNDEEP
excel-formula
eenz
eenz

Reputation: 143

Using an excel vlookup with wildcards

I have a large data source that I cannot edit - so I cannot insert or modify any columns. I have a large serial number, about 15 digits long, and I am only concerned with the 9th, 10th and 11th digit which tells me what the product code is.

So I'm trying to do some sort of vlookup that allows me to search for the 3 digit product code I have within the large serial number.

Say my code is 333 and the serial number is 000101903339098. I want to do a vlookup with 333 as the lookup value and find all the products that have 333 in their serial numbers.

Any ideas how to do this?? I think I have to use some sort of wildcard character but I'm unsure how do that

Upvotes: 0

Views: 67

Answers (1)

David S
David S

Reputation: 231

Using an array formula you can get it all in one cell.

{=TEXTJOIN(", ",TRUE,IF(NUMBERVALUE(MID(A2:A9,7,3))=E1,B2:B9,""))}

enter image description here

Upvotes: 2

Related Questions