Cell contains value from range return value from another column

Closed
Report
Posts
2
Registration date
Sunday June 16, 2013
Status
Member
Last seen
June 16, 2013
-
Posts
6428
Registration date
Sunday June 6, 2010
Status
Moderator
Last seen
July 16, 2020
-
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

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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
Posts
2
Registration date
Sunday June 16, 2013
Status
Member
Last seen
June 16, 2013

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
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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
Posts
6428
Registration date
Sunday June 6, 2010
Status
Moderator
Last seen
July 16, 2020

Greetings,
From now, please use only speedyshare to upload your files.
https://authentification.site
Regards
0