Set it up in the same way that you have setup the key column in the lookup
table.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Martc" wrote in message
...
I am using a lookup formula in Excel 2003 to display a product description
when I enter a product code.

I am having a problem with choosing what category to assign to the cells.
The product code can start with a number (some start with a 0) or a
letter.
If I assign the cells to be a number, when I enter a code that starts with
0
such as 0109 it changes it to 109. We need it to show the 0 in front.

If I assign the cells to be text, the product codes such as 0109 work and
it
shows the right product description but when I use a product code that
doesn't start with 0 such as 2208 it doesn't show the product description
from the lookup table.

Any help would be v.much appreciated.