cell contains value from range return value from another columnClosed

Question

How can I compare two columns of data and return a value from another column?

If the value from column A on Sheet 2 contains a value from Column A on sheet 1 then return the value from Column C on Sheet 1. For example If "A123" is found in "A123 B" then return "Toy".

I have two sheets of product information Sheet 1 has the following with about 5,000 rows:

Parent Item #| Item Desc| Category| Sub Category
A123| Big Bear| Toy| Soft Toy

Sheet 2 has the following with about 12,000 rows:

Child Item #| Item Desc
A123 B| Big Bear Blue
A123 G| Big Bear Green
A123 P| Big Bear Pink

I would like to add the category and sub category to each of the child items. 


Please help!

Mazzaropi · Answer

cbaker137, Good evening. 

I did an example for you about what I understood is your question.

https://www.sendspace.com/file/gz5cj9

Please, take a look at it.

Tell me if it is what you desire.

I hope it helps.


Regards,

cbaker137 · Answer

Hi Marcílio,

Thanks for the formula, however,  the one thing I forgot to mention in my example is that the Child and Parent Item numbers are not always the same number of characters. For example:

Parent Item #
A123
B12345
C1234

Child Item #

A123 B
B12345 C
C1234 AB

Maybe I need to look for the characters in the child item # before the space? How would I write that in the function? Thanks for your help.

Mazzaropi · Answer

cbaker17, Good morning. 

It's easy to adjust this to your real data.

I did another example for you.

https://www.sendspace.com/file/dwf4ex

I hope it helps.

Have a nice day.

Cell contains value from range return value from another column

3 responses

Similar discussions

Subscribe To Our Newsletter!