I want to be able to enter a product code in one column and based on the code
i have entered, get the product description to automatically appear in the
column next to it.

There are approx. 150 product codes and descriptions.

I have all of the data saved in a separate spreadsheet, but can hide it on
the active spreadsheet if necessary.

Can this be done? (Please explain in simple terms!!)

Thanks!