The feature you're looking for is called VLOOKUP........check out the HELP
section for "VLOOKUP worksheet function" and give it a try........post back
here if you need any help.

Vaya con Dios,
Chuck, CABGx3



"willb" wrote:

I would like to have a set of names assigned to certain numbers for inventory
purposes, such as, each time that '12345' is typed in any row in the first
column the corresponding row of the second column will say 'Product A.' It
would also have to respond in such a way that if '34567' is typed in the same
location, 'Product D' would be displayed.

Thanks for any help.