I have a program that gives me agency codes (ex: S389) in a report but doesn’t give me the agency it pairs with. (S389 pairs with a certain location, say Washington.) So I have a table that lists the locations and the agency code that pertains to each on a separate worksheet. I want to add a column to the original report to show what location it pairs with. What function can I use for the new column for it to automatically register the location based off of the agency code?