Keep current cell value if there is no match with index/match

Joanna Collins

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!

Genevieve P.

Hi @Joanna Collins

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

David Tutwiler

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

Joanna Collins

Thank you for your reply! I will submit a feature request.

Genevieve P.

Hi @Joanna Collins

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

Joanna Collins

Thank you, I will try that!

Joanna Collins

Thank you!