I have a colum where the listings may contain "A", "B" , "C", or "D". No numeric characters...well from there I want to state that if
A1="A" then output is "Joe"
A1="B" then ouput is "Joe"
A1="C" then output is "Jane"
A1="D" then output is "Dave"
I was sure pretty sure that the statement was an IF function and may contain an ELSEIF but I can not seem a source to show me if I am right or wrong, nor can I produce the outcome. Could some please point me in the right direction?
This is what I came up with
=IF((AND(T2="PC", T2="MP", T2="AC", T2=FC)),"VSD","VSV")
Bookmarks