lookup-type of macro

Hi

I basically have a very easy task I need help on (usually not working with excel at all). I was hoping someone might have a sample macro or an idea how I could solve this. I think everyone that has ever worked with Macros probably knows a solution to this:

I have a worksheet with 3 colums, containing a product number, a product code and a product description. All I need is a kind of a user prompt, where the user can type in the product number, and gets the prod. code with it's description back. Should be able to find the product with an incomplete entry (kind of type-ahead).

If anyone can help with a sample or something... it's greatly appreciated!