I would like to use lookup to save some copy/paste time when sheduling people…
I have these columns in my end table:
This is the table from which I want to drag the data:
What do I want to achieve:
When I enter a name in the first table (column “Name”), I want the columns Team & Teamlead to be filled automatically via lookup from the second table.
Whatever I tried I did not manage to achieve this.
- [List of Support Agents].Lookup(Name, thisRow)
- [List of Support Agents].Lookup(Team, First(List(Team)))
- and a lot more…
Can someone help me?