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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies