Thank you, Sheeloo!

I did as you suggested and it worked.

Thanks again.
--
Thank you,

scrowley(AT)littleonline.com


"Sheeloo" wrote:

Yes, that may work...

Now if you have contacts and their company (client is same as company, right?)
names on Sheet2 then why not simply copy those two columns over to Sheet1?
You can always sort on Comany name...

Since contacts would be unique not the company, you should look for company
name
given a contact...Simple VLOOKUP will do.

What am I missing here?

btw what does C[38] signify... I believe it refers to 38th column from C1...

"Sandy Crowley" wrote:

Maybe I should start over:

Sheet 1 has unique names of all the Clients in C1 (each Client per Row = 526
Clients)
Sheet 2 has a list of all contacts and the companies they work for (Table
Array Sheet 2 R2C1:R4476C[38]
I would like to return all the contacts that relate to each client. I'll
Fill the formula down and over and I need at least 8 rows to allow for 8
different contacts per Client.

How would you write that nested formula?
--
Thank you,

scrowley(AT)littleonline.com