Data Recognition

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?

By: Christian

Leave a Reply

Your email address will not be published. Required fields are marked *