Actually, my formula should give you the results you're looking for.
Same thing with Leo's formula. What are you getting?

In article ,
Dan wrote:

Sorry, I wasn't very clear, what in need is this:

A1:021-310L B1:107803
A2:021-310L B2:109851
A3:021-310L B3:109551

so when i enter in a1 on a seperate sheet i would get this:

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

Thanks Again!


"Domenic" wrote:

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!