gistfile1.txt

=INDEX( # Returns the content of a cell
    # Reference
    FILTER( # Returns a filtered version of the source range
        Legendaries!A:A, # Condition 1: All Legendaries
        Legendaries!B:B = A2 # Condition 2: The Name column matches the name in A2
    ),
    #Row
    MATCH( # Returns the relative position of an item in a range
        # Search Key
        MAX( # Returns the maximum value in a numeric dataset
            COUNTIF( # Returns a conditional count across a range
                FILTER( 
                    Legendaries!A:A, 
                    Legendaries!B:B = A2
                ), 
                FILTER(
                    Legendaries!A:A, 
                    Legendaries!B:B = A2
                )
            )
        ),
        # Range
        COUNTIF(
            FILTER(
                Legendaries!A:A, 
                Legendaries!B:B = A2
            ),
            FILTER(
                Legendaries!A:A, 
                Legendaries!B:B = A2
            )
        ),
        # Search Type
        0
    )
)