vLookup Maybe?

Hello Everyone,

Another day, another peoblem with excel. I was hoping someone on this board can help me out. I am trying to write up a vLookup query to pull information from the data set so I can create my own table for testing purposes. I have attached the sample data in this post.

Basically, I am conducting an test on the users within the LDAP system for appropriate access. I wrote a function in column A to assign a unique number to every set of data. So each person may have multiple line items to them...for example, someone with two direct reports may have two line items than the person with no direct reports. i would like to be able to pull the data from column B within this large population based on the number in column A (which assigns each grouping its own number). Maybe a vLookup that would say, column A = 1, column B starts with cn:

I'm not really sure if this is even the way to go about it. I hope i've explained it well enough but if not, I'll be around to answer any clarifying questions.

Thank you for your time.

Thank you for your reply NBVC. I do see what you're trying to do here, but I'm still getting a #N/A when I put in the formula in M1, and the data from column A in L. Any clues?

NBVC, I stand corrected, the code you provided does work. But that initiates another problem though. As shown in the sample data set. one user can have multiple items for their account. In the case of this audit, I have a spreadsheet with over 400,000 line items and 8,000 users - so say 50 line items per user. With the code that you provided, it gives me the data I'm looking for, but 50 times. Is there another step I can run after this to pull the value once from each user instead of the 50 times?