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...
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 (* ?)
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?
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.