I had a similar question and searched for something like VLOOKUP from Excel and got this create answer from Betty:
Step One - Create a table with e.g company names. You will use this when assigning companies to employees through the People lookup table.
Step Two - Create a table with e.g. employees, and the companies they work for.You can format the Company column as “Lookup from Table” to pull data from the Companies table created in step one.
Step Three - Create a task list, formatting the assignee column as “Lookup from table,” so you can use the data from the People table created in step two. If you want to view the company the assignee works for, set the formula of the third column to be =Assignee.Company.
So I guess this would be also a easy solution for you.
4 Likes