Assign column

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

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

--

HTH

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


"MK" <[email protected]> wrote in message
news:[email protected]...
> 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

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!
==============================================


"MK" <[email protected]> wrote in message
news:[email protected]...
> 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