text reference to number value?

[Scott]

I have a spreadsheet with a Product code number that I
want to revise to a Description (reference on another
sheet). Is there an easy way to lookup and reference?

 

[Jason Morin]

Assuming the description is to the right of the product
code number on the other sheet, try:

=VLOOKUP(A1,OtherSheet!A:Z,2,0)

where:

A1 = location of product code number to look up

OtherSheet!A:Z = list of product codes, descriptions, and
other info

2 = the 2nd column in OtherSheet!A:Z. In this case, it's
col. B where the description is located (assumed)

0 = find an exact match.

HTH
Jason
Atlanta, GA