Global Updates and using VLookup formula in it.
Options
Comments
-
you cannot do a Find replace in smartsheet. Meaning you can't actively change one cell from another without referencing them.
If you want to replace vlookup, I recommend Index(Match()).