Excel and Word Recognition Formula

**vagal456** · 10-10-2012, 01:38 PM

Hi,

I have two spreadsheets. One is a list of products in one column, and where they are being sent in the column next to it.

I.e.

Column A Column B

Chocolate Cadburys

Sandwich Tescos

I have another sheet in the same document that is categorized by where the product needs to be sent. Is there a formula I can apply, so that whenever a product in sheet one is to be sent to that place, it is automatically added to the second sheet in the correct category.

I.e.

Column A Column B

Cadburys Chocolate

Tescos Sandwich

So anytime I add a new product to sheet one that i need to send to Cadburys, it is recognized as being part of the cluster for cadburys in sheet two and added there?

Thanks for any help! I’m new to excel.

**dwint** · 10-10-2012, 01:48 PM

please see attached file

**vagal456** · 10-10-2012, 02:13 PM

thanks but i tihnk i need to explain what i am trying to do better.

In sheet one i will list each product, and next to it put all the places it needs to be sent like below:

Column A Column B

Chocolate Cadburys
Mars
Galaxy
Seven Eleven

Paper WHSMITH
Radioshack
Postoffice

Cocoa Cadburys

Is there a formula so that whenever I type the word “Cadburys” sheet two recognizes it and automatically adds it to the cluster of products being sent to cadburys.

So sheet 2 would end up looking something like this:

Column A Column B

Cadburys Chocolate
Cocoa

WHSMITH Paper

Does this seem possible?