Thread: Excel 2007
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Di_W Di_W is offline
external usenet poster
 
Posts: 8
Default Excel 2007

I have a list numbers with set values. For instance:

0 = 123
1 = 456
2 = 789

If I enter a 0 into cell A1, I want 123 to automatically be entered into B1;
If I enter a 1 into cell A1, I want 456 to automatically be entered into B1;
If I enter a 2 into cell A1, I want 789 to automataically be entered into B1

Thanks for your help!
DiDi