How best to do the followin

Hi,

I have a spreadsheet that contains a company code in cell A3 to A150.
This company code uniquely identifies a company. These codes ones
assigned are not transferred to another company. What I want to do is
when a user clicks in a cell with the company code I want to reference
its company name. This way the user is not running around looking up
company names that are stored an another excel file . The company
codes are as follows:

0010-BBBB
0010-CCCC
0013-0000
0015-0100
0041-WOKS

So if a user clicks on cell a1 containing 0010-BBBB I want to return
Big Bass Outfitters and if they click in the cell contusing 0010-CCCC
I want to display Canada Water and so on and so forth

I was thinking about some how adding automatic comments by looking up
the company codes against the company name and inserting comments. But
I am not sure if its a good solution and if it can be done.

All suggestions are welcome.

Please reply here or reply to may email,

thanks,

Dave