Assuming that Sheet1, Columns A and B, contain your source data, and
Sheet2, A1, contains your part number, enter the following formula on
Sheet2...

B1, copied across:

=IF(COLUMN()-COLUMN($B1)+1<=COUNTIF(Sheet1!$A$1:$A$100,$A1),IND EX(Sheet1!
$B$1:$B$100,SMALL(IF(Sheet1!$A$1:$A$100=$A1,ROW(Sh eet1!$A$1:$A$100)-ROW(S
heet1!$A$1)+1),COLUMNS($B1:B1))),"")

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
Dan wrote:

Hello,

What i'm trying to accomplish is to get a list of all po's (purchase orders)
that we have on order for a certain part.

What i need to do is to get a list of all po's associated with a certain part.
part# po#
A1:021-310L B1:107803
A1:021-310L B1:109851

What i'm trying to get excel to do is to place the data like this according
to what part number is entered in the adjacent coloumn from another sheet
containing the data shown above, i tried using the {=SUM(IF formula but that
only added the po's, and =VLOOKUP only gives me the first one it finds.

A1: 021-310L B1: 107803 C1: 109851

Much thanks in advance!