My challenge is that I use a “select-formula” (in Table1) to choose a name from another table (Table2).
I have to do it like this, since there is no reference to Table2. This works fine. I get a dropdown of names to choose from.
But in the next row (in Table1) i would like to automaticly pick the matching phonenumber to that name in Table2.
Sounds easy? It’s not! I’ve treid Dereference, Lookup, Any, Select, IF, REF to viritual columns, ++.
I can get a list of phone nubers from table2, but not automaticly picking the one matching the name.
Any suggestions anyone?