|
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" wrote in message ... 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" wrote in message ... 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 |
| All times are GMT +1. The time now is 08:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com