I have Drawing ID in Column A, Material No in Column B, PO Nos in Column C.
I would like to get all PO numbers in Column E,F,G,H and so on.
I tried the below formula but does not get the right answer.
=(INDEX($A$1:$C$5,SMALL(IF($A$2:$B$2=$A$1:$B$5,ROW($A$1:$B$5)),COLUMN(A1)),3))
Need your help.
Bookmarks