I have set up an inventory of the chemicals we keep on an excel
spreadsheet... What I want to be able to do is to double-click on a chemical
(ie double-click in a cell) and be referred to new cell that lists the
synonym of that chemical.

In other words, when I double- click on 'salt' the spreadsheet moves me to
cell that says 'NaCl'... and thus, all of the pertinent information for NaCl.