Excel 2007

[Di_W]

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

 

[Di_W]

NBVC

I'm not understanding.

In sheet 1, cell A1 -- If I type a 0, I want 123 to be automatically entered
into Sheet 1, cell B1; if I enter a 1, I want 456 to be automatically entered
into Sheet 1, cell B1.

In sheet 2, I have typed a list:
0 = 123
2=456
3=789

Does that make sense?
Di

 

[Jacob Skaria]

Suppose you have the below list in Sheet2 ColA and ColB starting from Row1

ColA-ColB
0---123
2---456
3---789


In Sheet1 B1 enter the below formula (all in one line)

=IF(ISERROR(MATCH(A1,Sheet2!A1:A100,0)),"",INDEX(Sheet2!B1:B100,MATCH(A1,Sheet2!A1:A100,0)))


If this post helps click Yes
---------------
Jacob Skaria

NBVC

I'm not understanding.

In sheet 1, cell A1 -- If I type a 0, I want 123 to be automatically entered
into Sheet 1, cell B1; if I enter a 1, I want 456 to be automatically entered
into Sheet 1, cell B1.

In sheet 2, I have typed a list:
0 = 123
2=456
3=789

Does that make sense?
Di

 

[NBVC]

NBVC

I'm not understanding.

In sheet 1, cell A1 -- If I type a 0, I want 123 to be automatically
entered
into Sheet 1, cell B1; if I enter a 1, I want 456 to be automatically
entered
into Sheet 1, cell B1.

In sheet 2, I have typed a list:
0 = 123
2=456
3=789

Does that make sense?
Di

If your list in Sheet 2 is in A1:B3, then in B1 of your active sheet...
try:

=Lookup(A1,'Sheet2'!A1:B3)

You will need to change the sheetname and range if they are different
than in my formula.

 

[Di_W]

NBVC
Yes! This is very close to what I'm looking for.

I want to be able to type into Sheet 1 cell A25 any one of the numbers in
Sheet 2 cells A2-A11 (i.e. 0, 1, 2, 3, 4, 5, etc); with the corresponding
data to automatically insert into Sheet 1 cells B25-B34.

Example:
SHEET 1 SHEET 2 -Data
Row/Col A B Row/Col A B
25 3 343 2 0 316
26 5 356 3 1 327
27 9 376 4 2 335
28 7 367 5 3 343
29 8 372 6 4 350
30 5 356 7 5 356
31 0 316 8 6 362
32 2 335 9 7 367
33 6 362 10 8 372
34 7 367 11 9 376

Thank you so much for your help.
Diane

 

[NBVC]

So in B25 of Sheet1, enter

=Lookup(A2,Sheet2!$B$25:$B$34)

and then fill down the formula to B34 of Sheet1