if statement

G

grammy

I want to write a statement that says if option code = eefam, then 003, if
option code = eechd, then 002, etc.
Option Code
EEFAM EESP 003
EEONLY EECHD 002
EESP EEONLY 001
EESP EEFAM 003
 
K

Kevin Vaughn

If 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.
 
D

Duke Carey

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 value
 
Top