In column E and F, I have multiple values and amounts. For example:
Column E Column F
321 $775.00
557 $50.00
395 $45.00
321 $54.00
574 $65.00
321 $85.00

I want to be able to have Excel search for all the dollar amounts that have
a corresponding 321 in Column E, but place these amounts in different cells.
In the example above, I'd like $775.00 to appear in cell A1....$54.00 appear
in cell A2...$85.00 in cell A3 and so on until all dollar amounts with a
corresponding 321 are listed.
Any suggestions on how to do this with using a Filter?
I know Sumproduct will add the amounts together...but I want them listed
seperately....and Vlookup will only return the first dollar amount that
matches that requirement. So I'm not sure what formula to use.