Assign column

[Guest]

Example two column X and Y
Assign A= S$500
B = S$1000
C = S$1500
If key A in column X, Y automatic display S$500
If key B in Column X, Y automatic discplay S$1000.............

Can the above be possible

 

[Bob Phillips]

=IF(X1="A","S$500",IF(X1="B","S$1000","S$1500"))

--

HTH

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

 

[RagDyer]

One way.

Enter this in Y1, and copy down as needed:

=LOOKUP(X1,{"A","B","C"},{"S$500","S$1000","S$1500"})

You can expand on this and add more values, if need be.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================