Filter Function to to return Data based on Partial text

[Ramadan]

I have this filter function to collect data based on the client name in Cell "B3" from all my sheets and it works good only if cell "B3" has the exact full name the same as intered in the sheet otherwise I get wrong result

this is my formula

=FILTER(District1!B:D,(District1!G:G=B3)+(District1!I:I=B3)+(District1!K:K=B3)+(District1!M:M=B3) and I repeat this function 8 times to get data accros my 8 sheets. so far it works fine

it simply check for the client name in 4 columns (G,I,K,M) in each sheet to give me the client information in (B:D)

But because names might be intered sometimes in a different way through our users, so I tried to edit the formula to collect any data with a patrial text either if first or family name was intered in B3...... NOTE: (first and family name are always both intered in one cell).. and I made it like this below

=FILTER(District1!B:D,(District1!G:G="*"&B3&"*")+(District1!I:I="*"&B3&"*")+(District1!K:K="*"&B3&"*")+(District1!M:M="*"&B3&"*"))

but it stoped giving any result while there is a true match

Can you please let me know how to fix this probelm and please put in mind that I will repeate this part of function 8 times to check 8 sheets

Thank you in advance

 

[hagia_sofia]

Hello, maybe something like:

=FILTER(District1!B:D,ISNUMBER(SEARCH(B3,District1!G:G)))