Why is my Index Collect formula not working?
My source sheet contains information associated with clients, including site locations, managers, addresses, email, and phone numbers. My destination sheet includes rows with that site information. In some cases, a client has multiple sites. To capture all of the sites (rows) associated with a particular client, I added a column with site numbers (01,02,03, etc.) so that the formula looks for the client name and the site number. Here's the formula:
Unfortunately, I'm getting an Incorrect Argument Set error.
Thanks in advance for any help you can provide.
Help Article Resources
Check out the Formula Handbook template!