Xlookup Formula

Vicente Coelho

Is there a plan to include the new xlookup formula from Excel?

L_123

I don't see them doing this as smartsheet has the collect formula which can perform the same task when wrapped in an index.

=index(collect(A:A,B:B,1),1)

Will return the value in A where B is 1. Just like Xlookup I didn't have to declare a single table, and instead used column or range references where my criteria and results are.

L_123

I don't see them doing this as smartsheet has the collect formula which can perform the same task when wrapped in an index.

=index(collect(A:A,B:B,1),1)

Will return the value in A where B is 1. Just like Xlookup I didn't have to declare a single table, and instead used column or range references where my criteria and results are.