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 replies

Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 146
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,
1
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.
0
Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 146
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.
0
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