Forum Discussion
Michael James
Nov 22, 2017Copper Contributor
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. ...
SergeiBaklan
Nov 23, 2017Diamond Contributor
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")