How to get the name of the company boss in excel through Qichacha?

E2 input

=VLOOKUP("*"amp;D2amp;"*",A:B,2,0)

Enter and down filling.

Or use

=INDEX(B:B,MATCH("*"amp;D2amp;"*",A:A,))

Also OK.