Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
MATCH Formula
OK I'm loving these new formulas but I need help with the MATCH formula. I have column A with serial numbers in it. I want to scan serial numbers into column B and use the MATCH formula to match it to column A. How would you write the formula?
Comments
-
MATCH returns an number, not the actual value.
To do that, you need to add it to INDEX.
I'm not sure what you expect to get from the two columns.
Can you post a screen shot?
Craig
-
Stephanie's problem has been resolved.
She was looking to use the MATCH function to find the position in the column and then translate that into the row number. She wasn't looking to retrieve any other information (which would require using the INDEX function)
So we just added the table's offset to the number returned by the MATCH function and Bob's your uncle.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives