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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives