Hi Shelley;

You can use VLOOKUP for the same.

Main Data sheet:

1 A AB 234
2 B AC 25
3 C AD 24
4 D SD 21
5 E GT 32
6 F HY 45
7 G DE 34
8 H WE 23
9 I AS 23
10 J WE 12
11 K TR 12

Result sheet

1(product id) =VLOOKUP(B18,B4:E14,2,0)

Hope this would help you.

Regards

Vikky


Shelley Kingston wrote:
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!