searching in excel

I have a spreadsheet with multiple worksheets. One worksheet contains 2 columns…one with product codes and a second with the product description. What I want to do is on the other worksheets have a formula or a macro that will search for the product code entered by the user and return the corresponding product description based on the product code entered. I have tried the LOOKUP feature but I don’t like the fact that if you happen to incorrectly enter the wrong product code it will returnthe next highest or lowest product description. Does anyone have any suggestions? Is there a formula in Excel that will do this? HELP!!