Ok people,

I have a list of companies
See Attached

I have the street addresses for 3 companies.

(Compnay) (123 Main St) (Houston) (TX) (713-555-1212)

How can I get excel to use the information above to locate the rest of the street addresses?

let me know please

Advanced Drainage Systems.xlsx