Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Search Search
Search for:
Tech Support Guy > > >

Excel Matching and Mapping Formula(s)


(!)

mattj925's Avatar
mattj925 mattj925 is offline
Computer Specs
Member with 1 posts.
THREAD STARTER
 
Join Date: Apr 2012
Experience: Intermediate
10-Apr-2012, 08:45 PM #1
Question Excel Matching and Mapping Formula(s)
Hello,

I have been struggling to figure out a formula/formulas that will help me match and map a set of categories to another set of categories. Bascially, what I am trying to do is match google's defined categories to my own ecommerce categories based on a 'loose' match, then return my categoryID. Ultimately, this will help save me some time categorizing products as oppose to the tedious venture of it doing all of the manually.

Attached is the sheet I am working with. In the first columns are Google's cat. hierarchy. Column J is my formula which I created using the help of a previous post.

ISTEXT(INDEX($W$2:$AD$10001,MATCH("*"&F2&"*",$W$2:$AD$10001,0),1))

I have it looking at the lowest level of the category hierarchy, looking for a match in my lowest level, then if no match, go on the to next level up and so on. I am having luck with *some* matches, however, I am having something like a 2.4% hit rate which isn't doing me much good. Now, I know I won't have 100% and I know some matches may give back an incorrect match (i.e. bicycle / recycle due to the wildcard inputs), however, any amount greater than 50% would save me a ton of time. Ultimately, I'd like to take this a step further and return the CategoryID (Col V) associated with the given match from my store.

If anyone is out there that could take a look or offer some suggestions/solutions/help; I'd greatly appreciate it!!!

Thank you,
Matt
Attached Files
File Type: zip categorizing products formula.zip (322.9 KB, 9 views)
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
coding, excel, excel formulas

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2