XLOOKUP

XLOOKUP helps you search a specified range in DBSheet and return matching results in a formula field. It provides the tools you need to perform exact or approximate matching, combine lookups with other functions, and keep calculated values updated automatically as source data changes. With XLOOKUP, you can create a formula field, enter the function with flexible parameter formatting, use referenced ranges and conditions, and nest the result inside functions such as IF or AND for conditional logic. It also supports automatic calculation after data import, so results are filled without manual triggering. Whether you're building lookup formulas, troubleshooting parameter or data type errors, or testing formulas before applying them more broadly, XLOOKUP helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53