Okay so i have a this formula:

=ArrayFormula({"Manager:";IF(D5:D="",,IFERROR(VLOOKUP("*"&REGEXEXTRACT(D5:D,"[a-zA-Z] ")&"*",'Client-Manager'!A:B,2,FALSE),"NO MATCH"))})

It works fine with what i have it doing now but i'm running into a problem now were i need to compare both last and first name and i can't figure out how to do it.

Here is an example sheet: