Forum Discussion
Solved
How do I get repeating part numbers (data) to auto fill data.
Sorry I am not very Excel savy but I was tasked with filling a spreadsheet with data of our part numbers, their description, the supplier we get them from, our assigned supplier numbers, and our supp...
FYI, this question was answered already in the thread in the link below:
HelloeXile821,
Create a master table with unique part numbers and their details. In your main sheet, use XLOOKUP or VLOOKUP to auto-fill repeating part numbers. Example XLOOKUP for Description: =XLOOKUP(A2, Master!A:A, Master!B:B), and adjust the return column for Supplier, Supplier Number, and Supplier Part Number. With VLOOKUP: =VLOOKUP(A2, Master!A:E,2,FALSE) and change the column index for other fields. Converting the master list to an Excel Table ensures formulas expand automatically when new items are added. This fills all repeated part numbers without manual entry.