software

I want to write a statement that says if option code = eefam, then 003, if
option code = eechd, then 002, etc.
Option Code
EEFAMEESP003
EEONLYEECHD002
EESPEEONLY001
EESPEEFAM003If you could leave the option codes in the same column, then a vlookup would
work. Either

=VLOOKUP(A7,A1:C4,3,FALSE)
or
=VLOOKUP(A8,B2:C5,2,FALSE)
depending on whether your option codes were in column a or column b.

--
Kevin Vaughnquot;grammyquot; wrote:

gt; I want to write a statement that says if option code = eefam, then 003, if
gt; option code = eechd, then 002, etc.
gt; Option Code
gt; EEFAMEESP003
gt; EEONLYEECHD002
gt; EESPEEONLY001
gt; EESPEEFAM003
gt;

with the table below in cells A1:C4 (change the 4 to whatever is necessary),
use:

=VLOOKUP(value,$A$1:$c$4,3,false)

where value is the code you want to associate with a valuequot;grammyquot; wrote:

gt; I want to write a statement that says if option code = eefam, then 003, if
gt; option code = eechd, then 002, etc.
gt; Option Code
gt; EEFAMEESP003
gt; EEONLYEECHD002
gt; EESPEEONLY001
gt; EESPEEFAM003
gt;