Forum Discussion
Related, Relatedtable, Lookupvale
Hello, i got a short question: i was trying to build up a relationship between 2 sheets. Since it doesn't work automatically i thought about building a relation via lookup() formula or related()...
Relationships are built in the relationship editor. This thing here:
Those formulas make use of existing relationships. They don't create them.
...
Well, lookupvalue actually doesn't require or use relationships. It just looks up columns conditionally based on other columns. In any case, it still doesn't create relationships.