Auto Populating in Excel

Occasional Visitor



The company I work for uses excel to keep track of customer complaints for specific SKUs that they sell. We also use Excel to perform basic metrics to track and trend data.

My question here is that I want to have 2019's spreadsheet auto populate the product name and the manufacturer when the SKU is entered into a column.

For example: Column A is the reported SKU and then in Column C the product name will auto populate.


I would also like to know how to lock out the auto populated columns so that other users will not be able to change the data. I already have another sheet within the workbook that has all the SKUs, product names, and manufacturers listed. The difficulties I keep running into are the duplicate manufacturers for most of the SKUs.

Related Conversations
Teams no longer auto launches
trandall in Microsoft Teams on
4 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies