Automatic "Cell linking"

ClayBuell

*What would be the best way to create a permanent link between cells.  

What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automatically.  

We basically develop real estate and the project might start out known as the "Nome project" and gets assigned a Project Number.  

I want a way to "link" up all four of these bits of project info so they're always stay together.  

Is this possible without a third-party app?

 

** This is a fictitious project example **

Andrée Starå

Hi,

Interesting!

Not sure I follow!

Would you want all values to link up regardless of which value is filled in first?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

ClayBuell

Yes I would like to have them linked up regardless of which value was filled in first.  

Andrée Starå

The problem would be that as soon as you add value, it would replace the formula in that field.

Would it work for your use case?

Where would the "Master" data be? In another sheet?