Formulas/Scripts That Cross Reference & Import Data

[ekeithjohnson]

I am not a frequent user of Excel and I have never used a macro to perform certain functions but I have a project that likely could use a macro to achieve what I desire.



Can column code data be cross referenced to a master list to display the description of the code? For example, data in a column is a facility code. I have a separate master list of all facility codes. Can a formula/script be written that takes the facility code then goes out and cross references the code in the listing and import the facility name in a new column? Similarly, another column contains data that is an operation code. I have a separate list of all operation codes. Can a formula/script be written that take the code then goes out to the listing cross referencing it and imports the code description back into another new column? In another column I have a tracking number is unique for each record and would be the link in the records.

Is this possible to achieve in Excel without an enormous amount of work?

Thanks.

Keith