Global Updates and using VLookup formula in it.

adwitiy.singh · 03/14/19

Hello all,

I wanted to know is it possible for us to do find and replace in global update and change a Vlookup formula or to introduce a new Vlookup formula.

I am trying to do that and i am not successful in accomplishing that.

Please some suggestions.

L_123 · 03/15/19

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()).

Global Updates and using VLookup formula in it.

Comments

Categories