Cell contains value from range return value from another column

Closed
cbaker137 Posts 2 Registration date Sunday June 16, 2013 Status Member Last seen June 16, 2013 - Jun 16, 2013 at 06:00 PM
jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020 - Jun 17, 2013 at 10:02 AM
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!

3 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 16, 2013 at 06:54 PM
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 Posts 2 Registration date Sunday June 16, 2013 Status Member Last seen June 16, 2013
Jun 16, 2013 at 08:42 PM
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 Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 17, 2013 at 06:54 AM
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.
jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020
Jun 17, 2013 at 10:02 AM
Greetings,
From now, please use only speedyshare to upload your files.
https://authentification.site
Regards
0