Keep current cell value if there is no match with index/match
![Joanna Collins](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Good Morning,
I would like to use an index/match formula on this sheet. It would update the wood/metal/glass columns if there is a match to the tracking # on another report that would be updated. If there is not a match, instead of returning "no match" I would like to keep the current selected values in that cell. Is this possible? If so, any help on the formula would be greatly appreciated!
Best Answer
-
To add to this, if you had a set default value, you could use an IFERROR to display a default value if there's no match, like so:
=IFERROR(INDEX({Return Value}, MATCH([Match Value]@row, {Match Value Column}, 0)), "Default Value")
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
I don't think Smartsheet currently supports a formula that can maintain the current value of a cell. But you could submit a feature request by filling out the form here:
https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409
-
Thank you for your reply! I will submit a feature request.
-
To add to this, if you had a set default value, you could use an IFERROR to display a default value if there's no match, like so:
=IFERROR(INDEX({Return Value}, MATCH([Match Value]@row, {Match Value Column}, 0)), "Default Value")
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thank you, I will try that!
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!