Great function, but I don't think it will help me in this situation. I've used the Mlookup function to compare columns between two different workbooks. It looks up a job ID in the table, and returns the name of the company in the next column. I used Mlookup because the same job ID can be associated with more than 1 company. It finds the job ID, and gives me all the different company names it is associated with.

For example, Mlookup browses through 15k+ lines of data, and will return in one cell "Company A, Company B, Company A, Company A, Company F, Company E, Company F, Company Z"

So what I gain from that is that job ID is associated with only 5 companies. I don't want it to return every single instance of when it appears. Does that help?