It might be asking a lot but heres the plan:

I want my cell to tell me 2 things (part name and number). When i click on a
cell containing a part number is it possible for another cell to display its
name.

My first thought was whether you can make a cell display the contents of the
highlighted cell's 'Name Box'.