Currently trying to create an index function that returns multiple values horizontally. Currently when I run this formula using ctrl + shift + enter I get an #N/A
Current formula: =INDEX($B$2:$B$150, SMALL(IF(A$2=$C$2:$C$150, ROW($C$2:$C$150)-MIN(ROW($C$2:$C$150))+1, ""), COLUMN(A1)))
Ideally cell D2 would be cgsteen
Bookmarks