Question about string of characters search

[mrafiq44]

So i have a filed titled "Name" and then for every row with the "Name" field i can put on the row of address which is on next line

However in certain rows "Name" is positioned as " Name" or as " Name", is there someway for me to have a common variable perform my function.

There are about 10000 line and approximately 4250 have the name. please help.

 

[kweaver]

Would you show a more specific example?

 

[DanteAmor]

You can use the wildcard "*"

Ex:
=VLOOKUP("*name*",A4:B6,2,0)