Hello,
If there a way to combine all of the dlookup formulas since I am wanting the underwriter, region and line to fill in based on the prefix of the policy number?
Right now I have them separate:
'I am wanting the lookup to find the underwriter by looking at the policy prefix field and...