Partial name and address match

Hello,

I am trying to create a formula that shows whether my data file has a partial name match and partial address match with the addresses listed in a separate data file. I would also like to hide the rows with no data.

Can someone please help me with a formula or function.

Attached is a sample worksheet.

Thank you!

try this for
=VLOOKUP("*",$B$2:$C$3,1,FALSE) for name
and
=VLOOKUP("*",$B$2:$C$3,2,FALSE) for address

and for hiding u can filter,find blanks cells right click and hide
hope it helps

Thanks for the help, but I am trying to partial match the address from the Data tab and Address tab. Under the template tab, Row 2 and column A is supposed to have "Yes" because the addresses do partially match, however, it comes up as "No" even though they do partially match. I was hoping you could help me modify my existing formulas or help me create a better to formula. I would like the rows on column A to let me know if any addresses from the address tab partially match the address from the data file. If it does partially match, then I would like to have "yes", if it doesn't then I would like to have "No".