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

Closed
Report
Posts
1
Registration date
Thursday October 15, 2015
Status
Member
Last seen
October 15, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
could you post a sample book some where and post back the link to the file and reexplain what you want
0