Excellent Dave, that does the trick for my named ranges.

Would you know how would I go about adding the values in a "Pay Per Client - Monthly" named range when there is a match in the "Client" named range so that I can calculate the profit per client selected? I was trying to use the SUMIF function:

=SUMIF(Clients,"*"&H4&"*",PayPerClient) - It would add all employees that are being paid for that working for that client.

This gives me a "0" value. Is this because my named ranges have text, numbers and blanks?