XLOOKUP ?

Options

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

Formula VLOOKUP or maybe an alternative solution
Hello, I am trying to develop a formula that will reference another sheet and bring back the content from a specific cell. Need to reference two columns for the match in the reference sheet. The match component will come from a column [PI or Account #] on the main sheet to be searched in column 1 on reference sheet and…
Concatenate Formula in SmartSheet
I am in the process of migrating workbooks from Excel to SmartSheet, but am having trouble with the Concatenate formula. I have a column of store numbers and am trying to automatically create the store manager email to be used across different sheets, but I cannot use the concatenate formula in SmartSheet the same way as…
Text to populate when Box is Checked
I need to populate text in a cell when there is a box checked anywhere within a row. This is what I came up with, but it isn't working =IF([Weekend Travel:WeekendTravel]@row = 1, "Weekend Stay")