Yes. Use
=VLOOKUP(A1,Table,2,False) with code no. in A1 and lookup range named as
Table or
=VLOOKUP(A1,sheet2!A:B,2,False) with lookup range in Col A & B on sheet2

"Matt" wrote:

Hi Excel Masters,

I think there would be a way to this but i wouldn't know where to begin.

I am working in Office 2007 1st off and I have a large customer spread sheet
i'm working with. One of the columns is our customer class which is a 2
character field. That 2 character filed (code) is tied to a description. If i
have 2 columns next to each other can i have 1st column where i wouuld enter
02 for the code it would fil in the cell in the next column wth a description
I set up in a table? i.e

02 Dry Goods Customer (the 'dry goods customer' would auto fill from the
02)

Thanks for any help with this,
matt