Bugs/issue in Google Sheet formulas

Google Sheets
1

I’ve found a bugs/issues in some of the Google Sheet formulas.

Insights tab - cell B20 has:

=arrayformula(
    if(
        row(B20:B30) = row(B$20),
        "Group",
        iferror(
            vlookup(
                $C20:$C30,
                {
                    INDIRECT("Categories!$" & P18 & "$2:" & P18 & "$201"),
                    INDIRECT("Categories!$" & P19 & "$2:" & P19 & "$201")
                },
                2,
                false
            )
        )
    )
)

But it should be:

=arrayformula(
    if(
        row(B20:B30) = row(B$20),
        "Group",
        iferror(
            vlookup(
                $C20:$C30,
                {
                    INDIRECT("Categories!$" & P18 & "$2:$" & P18),
                    INDIRECT("Categories!$" & P19 & "$2:$" & P19)
                },
                2,
                false
            )
        )
    )
)

To add a $ in front of the 2nd column reference and remove the 201 row limit so it looks at ALL rows.

2

The 200 row limit is because there is a 200 category limit in our template so this is more of a feature request than a bug :wink:

3

Oh really? I didn’t know that.

Why the category limit? Not that I will ever reach it but I’m curious.