Extracting values from a list?

Sample Data:
Col A: Col B:
CV01 01
CV01 01B
CV01 02
CV01 08
CV01 03
CV01 10
CV02 02
CV02 02B
CV02 03
CV02 10
CV02 01
CV02 09
CV03 06
CV03 06B
CV03 04B
CV03 05B
CV03 08
CV03 09

I need to generate/extract a "list" of all the values in Col B. that "belong" to each value in Col A. So, if my criteria is "CV02," I need the list to be 02,02B,03,10,01,09 (with each value in it's own cell)

I've tried the "VLOOKUP" function, but it only returns the last value for each criteria (example =VLOOKUP(CV01,A1:B18,2) returns "10")

I've searched these forums, but I'm not really sure what search criteria to use... I'm stumped. Any help would be greatly appreciated.

I just posted a suggestion to a very similar problem...

Check here:

http://www.excelforum.com/excel-prog...-the-text.html

Originally Posted by Tomkat

Thanks!

OK, I'll give it a try, but after looking at the formula, I'm not sure how to modify it to suit my exact situation.

Looking at the formula I supplied in the other thread and modifying it to more precise search

Please Login or Register  to view this content.

you would replace each instance of red $A$1:$A$100 with your actual range contain your lookup range.. you would replace the blue $A$1:$A$100 with the range of things you want returned..

The $B$1 is the cell containing your criteria to search for in the red $A$1:$A$100

Make sure to confirm the formula with CTRL+SHIFT+ENTER and then copy down.

I forgot to mention that even though the formula is on one sheet, the range that I want returned is on another sheet, but I finally figured it out... Using Bob's formula as a "template"

Please Login or Register  to view this content.

I tried using A:A instead of $A$1:$A$1000, etc, (since the range can grow indefinitely) but it didn't work, so I figured $A$1000 should cover it, hopefully.

Thanks for everyone's help!

Hey Try This UDF

Kindly find the Attached file

Please Login or Register  to view this content.