=IF(A1=A3,"w",IF(A1=B3,"x",IF(A1=C3,"y",IF(A1=D3," z",""))))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cheshire191" wrote in message
...
basically i want to do this equation

if a1=a3 than w
if not check to see if a1=b3 than x
if not check to see if a1=c3 than y
if not check to see if a1=c4 than z

and so on.

can anyone tell me what function or functions i need to use to do this. i
an
trying it with =IF and can't get it to work.