Lookup function support 3rd parameter to be optional


Version: 2026

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-32016


The 3rd parameter vref in Lookup() function is optional, so when lookup column A in column B, lookup(A, B) will get the row index of corresponding value in column B.