Formula

[Guest]

Can anyone show me the fomula under the condition of below ?

Column A1 got a list. List data = A,B,C
Column B1 will get info from another colum according what A1 appear.
Column E1=ABC
Column E2=BCD
Column E3=CDE

If,
A1=A
B1 will get answer from E1
if,
A1=B
B1 will get answer from E2
if,
A1=C
B1 will get answer from E3

Thanks

 

[Guest]

=If(A1="A",E1,If(A1="B",E2,E3))

Or dont use the columns

=If(A1="A","ABC",If(A1="B","BCD","CDE"))

 

[Guest]

Only use quotes "A" for text for numbers just put the number.

=If(A1="A",E1,If(A1="B",E2,E3))

Or dont use the columns

=If(A1="A","ABC",If(A1="B","BCD","CDE"))

 

[Roger Govier]

Hi

One way, provided the entries in A1 are always going to be single alpha
characters
=INDEX(E1:E3,(CODE(A1)-64))