Hypothetically I have a database in a workbook. That database consists of multiple contacts for various companies. I want a formula that will do the following...
On a new page in the work book I want to be able to put a company name in cell a1 and have this display, below it, the contacts who work for that company.
In essence I suppose it is a formula that when you enter a given value from a column it then displays results from other columns that also have that value in their row.
I have no sheet at present to share, I just need some guiding principals please.
Cheers
Bookmarks