I have a project where I need to match my company's disciplines with the previous client projects.
I have sheet one where I will list a client name in column A1 with disciplines used for that client in B1, C1, D1, etc.
Client two in A2 with discipline in B2, C2, etc.
Sheet two contains the disciplines in A1, B1, C1, D1, etc.
Is there a formula the hat would return a list of client names with that discipline on sheet 1 under the discipline heading?
I have sheet one where I will list a client name in column A1 with disciplines used for that client in B1, C1, D1, etc.
Client two in A2 with discipline in B2, C2, etc.
Sheet two contains the disciplines in A1, B1, C1, D1, etc.
Is there a formula the hat would return a list of client names with that discipline on sheet 1 under the discipline heading?