Then, you'd most likely use a PivotTable to analyze the data set that now includes the description for each product.
But, even if it slows things down, it still works. It's what we know, and it works well unless you have thousands of records to analyze. Most of us would use VLOOKUP() to add a column to the original data set. So, you import a table of shelving codes that includes a helpful description, but how do you add the description with each record? You've imported a table of products and each product has a shelving code, which is, meaningless to you. Now let's suppose you're working for a large grocery franchise and you want to analyze shelving data.
