search engine that shows company and established info from other fields

[Crool]

I need a search engine for company names eg a1, a2, a3, a4 and when i find the company it displays the name and the characteristics of the company such as, URL, PIN, contact email, etc.

I thought that if i validated the field i could revalidate it to show the rest of the information, but i can't see how.

Help please!!

 

[VoG]

Try VLOOKUP http://www.contextures.com/xlFunctions02.html