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

if(d3="SD000362","UU5C","false")

regards from Brazil
Marcelo


"Cacoe" escreveu:


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

sounds like Vlookup to me

=vlookup(what,which,where,logical)

What is the label
WHICH is the table containing the label in the first column and the
code value in the second or subsequent column
WHERE is the column number of the code value within the WHERE table
LOGICAL in this instance would be false, as if you DON'T get a match
you want an error.

Once I figured out VLOOKUP, it worked like a charm.

Thanks a lot.


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