Making a list of company names

Hi,

I would like to have a formula set up that looks through a column (A:A) and if a cell contains "Company Name," it will return the company name that is contained in the B:B column (i.e. "Company Name" is found in A3 so it returns B3). However, I have a whole list of company names, and that list might grow longer as more accounts are added. Additionally, because this is a tool for use by our salespeople, it wouldn't work for me to keep adding hard-coded references. The outcome that I'm looking for is a list of all the companies that we have accounts with. I was thinking along the lines of a vlookup, but that would only return the first company. Any thoughts?

Thank you

Capture.JPG

Can you see this attachment? I want to be able to have random stuff in A2:A3, A5:A7, and be able to add an unlimited number of names in B:B that will always update to output.