XLOOKUP ?

ameier

ameier ✭✭

03/10/22 in Formulas and Functions

Any plans to implement XLOOKUP in SmartSheet?

0 ·

Answers

David Tutwiler Overachievers Alumni

03/11/22

I believe you're looking for the INDEX function. This is often used in conjunction with a MATCH function:
INDEX - https://help.smartsheet.com/function/index
MATCH - https://help.smartsheet.com/function/match

0 · Share on Facebook Share on Twitter
ameier ✭✭

03/11/22

Thanks David

0 · Share on Facebook Share on Twitter
Steven Stikons ✭✭✭✭

09/01/22

We really need Array formulas in Smartsheet

1 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Is there a formula to update the status based off the % complete?
i.e % Complete is = to 0% then Status should equal not started, if % complete is > 0%, then status should be In Progress, if % complete is = to 100% then the status should equal Complete
Hello! I am trying to make a graph with these dates!
I am using a Grid Sheet and a reference sheet but can not figure out how to get the formula to match. I am using =COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2021, 12, 31))) This is my reference sheet formula =COUNTIFS({OnBoarding Partner Agreements Range 1} [Start Date]:[Start Date],…
Formula for numbering rows based on specific conditions
Hello! I need to create formulas for two columns that number rows based on specific conditions. I have a helper column (Number). First, I want to number rows that: Type is "Focus Group Volunteer" and Internal is "yes." Second, I want to number rows that: Type is "Focus Group Volunteer", Internal is "no", and Patron Type is…