Here is are a couple of quick tutorials on VLOOKUP: https://www.laptopmag.com/articles/excel-2013-vlookup, https://www.youtube.com/watch?v=DF6cpAuUPW8



Vlookup() is one of the simpler functions in Excel... you basically need a table that has the parts and descriptions, then you need to create the formula.

e.g

=VLOOKUP(A2,$Y$2:$Z$100,2,FALSE)

where Y2:Z100 is the range that your lookup table of parts/descriptions is in. A2 is where you type the part id you want to find the description for. The 2 means pull from the second column of the table, and FALSE means look for an exact match.