I have a column that may have hundreds of different entries. The entries
are not values; they may appear to be a value, e.g., 01252534 but it is
actually a label, or they may, and often do, appear more like this:
SD000362. Each entry is tied to a specific code, e.g., UU5C.

Is there is a function that I could use on the entire column that would
recognize the entry in let's say column C and spit out the code in
column D. For example if D3 is SD000362, then E3 would automatically be
UU5C?

If the answer is too lengthy, then a finger pointed to a resource would
be greatly appreciated.

Thanks, Cacoe.


--
Cacoe
------------------------------------------------------------------------
Cacoe's Profile: http://www.excelforum.com/member.php...o&userid=28894
View this thread: http://www.excelforum.com/showthread...hreadid=545892