To reiterate what I'm looking to do: I'm looking for all occurrences of a
given value in column A and looking to return the contents of their
corresponding cells in column B.

golddave wrote:
I have a worksheet where column A is a list of names (with duplicates) &
Column B is an order number. In column C I have a list of unique names
pulled from Column A (done manually for now). In Column D I'd like to list
all order numbers from column B that correspond to a particular name in
column C.

In this example I'm trying to figure out column D based in columns A, B & C:
A B C D
Wright A-1 Beltran A-21
Pujols B-3 Jeter C-22
Jeter C-22 Pujols B-33, J-22
Wright F-38 Wright A-1, F-38
Beltran A-21
Pujols J-22

Thanks.

--
Message posted via http://www.officekb.com