I am scratching my head trying to work out how to do the following:-
I want to be able to type an alphanumeric 'stock code' into an excel spreadsheet (E.G. "C000P8VWCW"), and have it automatically bring up the relevant 'Product Name' in the column next to it upon hitting the return key (E.G. 'PACK OF 10 HIGHLIGHTER PENS').
I know it is possible as an old work colleague did it a few years ago. I think he had a product list in a separate worksheet, that somehow linked into the stock codes. I cant figure out how he did it though.
Help would be much appreciated.
Note: I am using vista, with office 2007.
Apologies in advance for being a dumb a**!
Edited by Roger P, 03 November 2010 - 08:35 AM.