Help with Indexing! ASAP (Look up vertically and display them horizontally

[Michael James]

Hello All,

I need to be able to extract values vertically and display them horizontally. In the attached example, I have multiple instances with the same part number but with different prices. I want to be able pull those different values (prices) vertically and display them horizontally. The formula that I've typed get's me halfway there, but it's incorrect.

[#2]

Hi Michael,

Not sure about your formula, bit hard to recognize from the picture. Alternatively you may try as on this sample

=IFERROR(AGGREGATE(15,7,($C$2:$C$10)/($A$2:$A$10=$F2),G$1),"NA")