Global Updates and using VLookup formula in it.

adwitiy.singh

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

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