Index Match-Returning Duplicated Results

Question

&nbsp;Trying to compare to different machines and their results on similar samples. Trying to pull specific sample type results over to another sheet (hidden)But when it does it, it repeats the last pulled value repeatedly until it another match (sample type) is found.&nbsp;

nazsvegnyama · Answer

So index is the Cloud/pour, and the match is the sample type.
Is there a better formula to be using?
Or what can i do to make it so the top photo doesnt repeat the last value until another match is found?

harun24hr · Answer

FILTER() function may give you multiple result. Can you check do you have access to FILTER() function.

sergeibaklan · Answer

Nazsvegnyama&nbsp;
If without 365 for such sample

in I4
=IFERROR(
    INDEX(
        $E$2:$E$10,
        AGGREGATE(
            15,
            6,
            1 / ($C$2:$C$10 = $H$3) *
                (ROW($C$2:$C$10) - ROW($C$1)),
            ROW() - ROW($H$3)
        )
    ),
    ""
)
and drag it down till empty cells appear

Forum Discussion

Index Match-Returning Duplicated Results

Share

Resources