I'm trying to create a dictionary to add a solicitor's constituent ID based on a Team name.
It should work something like this:
Joes Team Solcitor 12345
SuperRunners Solicitor 23232
If the Team name is anything else, or the Team Name is blank, then the solictor ID should be blank.
Can anyone lend their expertise on this? Thanks!