Hello. I cam trying to create a database to make reviewing reports a little easier. I am essentially trying to create a file to use as a reference for this data. For example, I created a table that includes an associate ID number in one column with their name in another column. I am trying to set up a formula that will automatically fill in the employee's name with the corresponding ID number.
I am trying to do the same thing with product SKU numbers. Setting up a list that contains the SKU numbers with product description that can be automatically filled in for those that download missing the description.
I have tried a couple different methods I found while Googling but nothing that continues to work in the background and update automatically when opening the working document.
Any help would be greatly appreciated.
