Home

Vlookup vs ?

%3CLINGO-SUB%20id%3D%22lingo-sub-903170%22%20slang%3D%22en-US%22%3EVlookup%20vs%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-903170%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20state%20regulated%20metrc%20inventory%20system%20has%20a%20different%20naming%20convention%20than%20our%20inventory%20catalogue%20and%20I%20am%20having%20trouble%20using%20a%20vlookup%20formula%20to%20try%20to%20match%20the%20two.%20Should%20I%20be%20using%20a%20different%20formula%3F%20Example%20below...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECatalogue%20Name%3C%2FP%3E%3CP%3EAVO%2F18%20-%20Double%20Tangie%20Banana%20quarter%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMETRC%20Naming%20Convention%3C%2FP%3E%3CP%3EAVO%2F3833%20-%20Double%20Tangie%20Banana%20-%20A%20Bud%20-%2018%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-903170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-904301%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20vs%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-904301%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F423067%22%20target%3D%22_blank%22%3E%40MMarglin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EHow%20do%20you%20want%20the%20function%20(any%20function)%20or%20Tool%20(like%20Power%20Query)%20to%20identify%20that%20these%202%20products%20are%20the%20same%20to%20match%20them%3F%20is%20it%20by%20the%20left%203%20characters%3F%20is%20it%20by%20the%20sting%20following%20the%20dash%3F%3C%2FP%3E%3CP%3EIf%20there%20is%20no%20pattern%20whatsoever%2C%20then%20only%20YOU%20know%20the%20matches.%3C%2FP%3E%3CP%3EIf%20there%20is%20any%20identifiable%20pattern%20then%20combining%20the%20VLOOKUP%20with%20a%20Left%20or%20MID%20Or%20TRIM%20functions%20may%20help...%20or%20even%20with%20Wild%20Cards%20(*%26nbsp%3B%20%3F)%3C%2FP%3E%3CP%3ESo%2C%20what's%20the%20pattern%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-907255%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20vs%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907255%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Nabil%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%203%20characters%20in%20the%20beginning%20are%20the%20brand.%20The%20sting%20following%20the%20dash%20is%20the%20strain%20name.%20The%20problem%20I%20will%20run%20into%20is%20that%20multiple%20brands%20could%20have%20the%20same%20strain%20name.%20For%20example%20AVO%20-Double%20Tangie%20Banana%20is%20one%20product%20name%2C%20but%20we%20could%20also%20have%20Sunshine%20-%20Double%20Tangie%20Banana.%20Can%20the%20vlookup%20have%20both%20a%20left%2C%20mid%2C%20or%20trim%20funtion%3F%20Would%20I%20need%20to%20group%20the%20brands%20together%20first%20then%20do%20a%20vlookup%20to%20match%20the%20strain%20names%20within%20the%20brands%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EMatt%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-907308%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20vs%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907308%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F423067%22%20target%3D%22_blank%22%3E%40MMarglin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EDo%20you%20consider%20the%202%20products%20you%20mentioned%20as%20the%20same%20product%20(based%20upon%20the%20right%20side%20of%20the%20dash)%3F%20or%20in%20other%20term%2C%20which%20part%20of%20the%20name%20when%20present%20in%20both%20lists%20makes%20it%20the%20same%20product%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-907331%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20vs%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907331%22%20slang%3D%22en-US%22%3EI%20beg%20your%20indulgence%20to%20provide%20a%20sample%20file%20with%20manually%20entered%20results%20and%20explanation%20of%20the%20logic%20of%20each.%20In%20doing%20so%2C%20you%20will%20be%20able%20to%20satisfy%20the%20inquisitive%20minds%20of%20those%20who%20may%20probably%20furnish%20you%20with%20a%20desirable%20answer.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-907411%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20vs%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907411%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20are%202%20separate%20products%20because%20from%20different%20vendors%2Fbrand.%3C%2FP%3E%3C%2FLINGO-BODY%3E
MMarglin
New Contributor

The state regulated metrc inventory system has a different naming convention than our inventory catalogue and I am having trouble using a vlookup formula to try to match the two. Should I be using a different formula? Example below...

 

Catalogue Name

AVO/18 - Double Tangie Banana quarter

 

METRC Naming Convention

AVO/3833 - Double Tangie Banana - A Bud - 18

5 Replies

@MMarglin 

Hi

How do you want the function (any function) or Tool (like Power Query) to identify that these 2 products are the same to match them? is it by the left 3 characters? is it by the sting following the dash?

If there is no pattern whatsoever, then only YOU know the matches.

If there is any identifiable pattern then combining the VLOOKUP with a Left or MID Or TRIM functions may help... or even with Wild Cards (*  ?)

So, what's the pattern?

Thanks

Nabil Mourad

@nabilmourad 

Hi Nabil,

 

The 3 characters in the beginning are the brand. The sting following the dash is the strain name. The problem I will run into is that multiple brands could have the same strain name. For example AVO -Double Tangie Banana is one product name, but we could also have Sunshine - Double Tangie Banana. Can the vlookup have both a left, mid, or trim funtion? Would I need to group the brands together first then do a vlookup to match the strain names within the brands?

 

Thanks,

Matt

 

 

 

@MMarglin 

Hi

Do you consider the 2 products you mentioned as the same product (based upon the right side of the dash)? or in other term, which part of the name when present in both lists makes it the same product?

Thanks

I beg your indulgence to provide a sample file with manually entered results and explanation of the logic of each. In doing so, you will be able to satisfy the inquisitive minds of those who may probably furnish you with a desirable answer.

@nabilmourad 

They are 2 separate products because from different vendors/brand.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies