Identify value beside cell, match it against another column, then insert value next to it

[Scottcha]

Hi folks.

What I'm needing to do here is well beyond the scope of my Excel abilities, so I'm really hoping that someone could help me out.

Basically, there's a column with category names and a column with the category ID (which is currently blank). I need a way to identify the category name in each cell, reference a separate set of columns containing the category name and category ID, and then insert the current category ID into each cell beside it. An example might be easier:

Currently two columns side by side as so:

214589w.png

There are hundreds of category names in the column across thousands of products, and I need to insert the correct category ID beside each category name.

In another column, I have this:

anc979.png

Which lists the correct category ID for each category name.

What I need is a formula to insert in each AB cell which:

- Checks the category name value in column AC beside it.
- Finds the value in column AR (2nd image)
- When it's found, take the value in AQ to the left of it
- Insert this value into the AB cell where the formula is

The result would be that all of the category names in AC will have their correct respective category ID in column AB.

If anyone could help me with this I would be forever grateful. Thank you.

[dosydos]

Assuming the first category ID you need is in AB3 put this in AB3

=index($aq:$aq,match(ac3,$ar:$ar,0))

[Scottcha]

Assuming the first category ID you need is in AB3 put this in AB3

=index($aq:$aq,match(ac3,$ar:$ar,0))

You sir, are a genius.

I could have spent hours and hours trying to figure that out but you came up with a solution in about 45 seconds. Just shows what I know.

Thank you very much.

[dosydos]

Glad I was able to help.
If your question is solved please mark this thread as Solved by going to thread tools.