Finding terms in one word sheet & display on another word sheet

Closed
rmilos Posts 1 Registration date Thursday October 15, 2015 Status Member Last seen October 15, 2015 - Oct 15, 2015 at 09:35 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 16, 2015 at 02:21 PM
I have two work sheets:

Projects sheet that lists clients and the services we provided:

A B C D E F

3 AA Cabling Maintenance POS
4 BB Cabling Testing
5 CC Cabling
6 DD POS
7 EE Tele-com

And a Disciplines sheet. I want to search Projects and list all the clients ( AA, BB...) that used our services (disciplines)

A B C D E

1 Cabling Maintenance POS Tele-com Testing

All the companies that used our cabling service should be listed here in Row 2, Column A (Column A2 - A175)

All the companies that used our maintenanceg service should be listed here in Row 2, Column B (Column B2 k- B175)

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 16, 2015 at 02:21 PM
could you post a sample book some where and post back the link to the file and reexplain what you want
0