I’m so bad at formulas, I tried to make this lookup work for an hour now…
I’m trying to make my table adjust to the agent selected.
Example: If the Agent selected is Jay Lefebvre, then the table would input the name as Jay and the adjoint/adjointe as adjoint.
Any help is truly appreciated
Here’s the table: