Hi folks,

I'm not sure if this matters or not, but I'm using Excel 2007 to
create files used in 2007 and 2003.

I have a list of codes in a column with pertinent data in following
columns. Example of column 1:
CYAB
CYAM
CYYJ
CYYR
CYYT
OTHER

I would like to be able to enter a code on one worksheet and have that
input searched through the column for an exact match so that I can
refer to data along its row. If the code entered does not match any
in the list, I would like to be referred to the "OTHER" line.

I am stymied. Can anyone lend a hand?

Many thanks!
Craig