Forum Discussion
Help with Indexing! ASAP (Look up vertically and display them horizontally
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. ...
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")