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

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!