Forum Discussion
Need help autofilling.
Good morning all,
Thought I posted this but I am not seeing it anywhere so I apologize if this is a repeat.
I was tasked with filling in a spreadsheet with data including; Our part number, our description, supplier name, supplier number assigned by us, and supplier part number.
I noticed that a lot of the part numbers repeat so I am trying to find a way so that when the column with our part number repeats it will auto fill the columns with
the supplier name, supplier number and supplier part number automatically when I enter a repeating part number if possible. I am very much not excel savvy but I am pretty computer literate.
I have attached the document I am working on, there is no customer data what so ever and all part numbers are internal so are not proprietary.
https://gpcompinc-my.sharepoint.com/:x:/g/personal/zachv_gpcompanies_com/IQCj4grl62sHQYohshZJ9Mb2AX7_MknXYW1QiMk8wv2sdfQ?e=duyOxL
That is perfect,
Thank you for your help!
2 Replies
I created a lookup table (called PartNumbers) from the available information in your sheet containing all details for each unique part number. Then used XLOOKUP to retrieve the supplier name, supplier number and supplier part number from that PartNumbers table. Many part numbers have no (or incomplete details). That you'll need to fix yourself (if needed).
See attached.
That is perfect,
Thank you for your help!
