vlookup

[factoryf]

Hi Guys
looking some ideas on matching up some numbers in excel and i use vlookup all the time but this time i am matching wheel bolt patterns. normally part numbers i use fit some vehicles and that's it but with wheels on cars and trucks they can fit many so a vlookup will only return a match for the first part number but many wheels fit many cars is there a way vlookup can run and skip number that have matched in a previous match or column? open to ideas this is a sample from a look up i did
Genre1 SKU - PartNumber bolt patern Make Model Year
8x165.10 XD001208807115 8x180.00 GMC Sierra 3500 HD 2014 XD12721088724N
8x165.10 XD001208817115 8x180.00 GMC Sierra 2500 HD 2014 XD12721088724N
8x200.00 XD001208827115 8x180.00 Chevrolet Silverado 3500 HD 2014 XD12721088724N
8x170.00 XD001208877115 8x180.00 Chevrolet Silverado 2500 HD 2014 XD12721088724N

 

[mole999]

Re: vllokup

Vlookup can't work the way you want. I would be tempted to create a named range from your data and then use that in a Pivot Table, filtering on part number, but also could be set on known dimensions

 

[factoryf]

Re: vllokup

i do name the range but what i find is my list of year make model only gets the first part number that matches and all the rest get ignored and the rest i don't follow sorry

 

[mole999]

Re: vllokup

i do name the range but what i find is my list of year make model only gets the first part number that matches and all the rest get ignored and the rest i don't follow sorry

Thats using VLOOKUP, correct ?

 

[factoryf]

Re: vllokup

yes i use vlookup

 

[mole999]

Re: vllokup

as you started out, VLOOKUP can ONLY return one instance, hence why I was suggesting a PIVOT Table.

 

[factoryf]

Re: vllokup

i will have to look it and learn, i will report back.
thank you

 

[mole999]

Re: vllokup

plenty of youtube vids, and other data to help with

 

[factoryf]

Re: vllokup

i took a good look and watched some vids but i still fail to see how it will help my problem, right now i have around 2200 part numbers if i ran a vlookup for each part number and pasted all the data in one sheet i would the data but the time would be way to much. basically, i need to match all the ones that fit but unsure how to do that

 

[mole999]

Re: vllokup

with the Pivot from a named range, you would filter the pivot for the part number and it would show all the matches