You could do this by pasting the 10,000 product numbers, descriptions
etc into a grid on a tab in the workbook. Highlight the product number
and create a named range that refers to that range: a1:a10000, for
instance. Hide that tab, and on your invoice tab create an in-cell
dropdown (called data validation) that allows entries only from the
list that is contained in your named range. That way the user will be
able to select the part number or whatever from the dropdown, and the
Description, Price etc fields can populate with VLOOKUP formulas in the
invoice.