Maybe you could have an adjacent cell tell you the name all the time.

Debra Dalgleish has some nice instructions at:

http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

for using =vlookup() and =index(match())



AdrianCl wrote:

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'.

--

Dave Peterson