Better lookup formula

Roland

Implement xlookup equivalent.

Current "vlookup" sometimes requires complete sheet rearrangement to work, and can preclude a reverse lookup from working, where xlookup can lookup anything in the sheet from a key field.

Excel did this years ago and there's really no reason to ever use vlookup there on a new formula again.

Amanda Smith

I agree with Roland! XLOOKUP function would be extremely helpful. As you said, with the reverse lookup, as well as the reference columns. If you add/remove columns in the sheet you are referencing, you don't have to go and fix all your VLOOKUP formulas to capture the correct column.

Genevieve P.

Hey @Roland & @Amanda Smith

Just a headsup, you can use an INDEX(MATCH combination instead of a VLOOKUP in Smartsheet.

With this combination, you're referencing the two columns individually (the column to bring back data from and the column that has the matching value). This means you can re-order your columns in the source sheet as much as you want and it won't break your formulas.

Here's more information:

Formula combinations for cross sheet references | Smartsheet Learning Center

https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinations

There are countless ways to combine functions to analyze your data and make it more useful.

Cheers,

Genevieve