Forum Discussion
Solved
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,...
That is perfect,
Thank you for your help!
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!