# Formula to display contacts based on common criteria

1. ## Formula to display contacts based on common criteria

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

2. ## Re: Formula to display contacts based on common criteria

Hi jim,

This can be done ... do u have a sample data to post ? thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

3. ## Re: Formula to display contacts based on common criteria

I suppose I can put a dummy sheet together

5. ## Re: Formula to display contacts based on common criteria

Hi
This is arrayy formula
=IFERROR(INDEX(Database!\$B\$2:\$B\$20,MATCH(SMALL(IF((Database!\$A\$2:\$A\$20=Overview!\$B\$1)*ROW(\$A\$1:\$A\$19)=0,"",(Database!\$A\$2:\$A\$20=Overview!\$B\$1)*ROW(\$A\$1:\$A\$19)),ROW(A1)),(Database!\$A\$2:\$A\$20=Overview!\$B\$1)*ROW(\$A\$1:\$A\$19),0)),"")

6. ## Re: Formula to display contacts based on common criteria

Try the file attached.....

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1