What is the function of number one at the end of this formula?

cnb

=INDEX(COLLECT({Column to return}, {Column 1 with value to match}, "Value 1", {Column 2 with value to match}, "Value 2"), 1)

Thank you!

AravindGP

Hi @cnb

If you're asking about the number 1 in the formula, that is the row #. The function will pick the value from the first row where all the conditions match, i.e. first result it gets when it finds value 1 in column having value 1 and value 2 in column having value 2.

cnb

Thank you for your help! Your comment helped me troubleshoot and fix an issue I had. Much appreciated!