You should be able to do this with standard formulas, with no need for macros.
The VLOOKUP() function allows you to lookup a value (the lookup value) in a table and return a matching item.
If your table has the part number in the left most column, then the various elements such as connector, speed, size, manufacturer etc. in subsequent columns, VLOOKUP will find the part number and return values from any column to the right in the table.
As an example, if you have your table on Sheet2 with part number in column A (say 50 parts, so A1 to A50), with connector in column B (B1 to B50), and so on with say cost as the last element in Column G (G1 to G50),
then enter a part number in cell A1, and this formula in cell A2 will return the cost:
The 7 in the formula is because the result, in this case cost, is in column G which is the seventh column in the table
If the part number is not present it returns #NA, but this can be dealt with by a modification of the formula. See this :
BTW for most macros, you use a standard module, not a class module.