Keep current cell value if there is no match with index/match
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!
Help Article Resources
Check out the Formula Handbook template!