samedi 31 août 2019

Google sheet formula to swap names

I have this:

enter image description here

Image shows that those 2 cells contain input from another sheet.

Now, I want to input formula in those same cells that will rename inputs:

=if(D5="jerry.berry", "Berry Jerry", if(D5="perkins.aaron", "Aaron Perkins"))

Question: How do I insert the above formula next to =Source!H5

Note: I know I can modify those values on the root sheet itself, but I would rather not.

Aucun commentaire:

Enregistrer un commentaire