Global Updates and using VLookup formula in it.

adwitiy.singh ✭✭
edited 12/09/19 in Smartsheet Basics

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