Better lookup formula

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.

Sign in to vote!

Find more posts tagged with

Idea Submitted

Comments

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:

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

Cheers,

Genevieve

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.